Access DB

Results 1 to 2 of 2

Thread: Access DB

  1. #1
    Join Date
    Dec 1969

    Default Access DB

    I have been testing my application on an Access DB. I am now ready to publish it on the net and would like to start the primary key numbering from 1 again. Is there a simple of doing this?

  2. #2
    Join Date
    Dec 1969

    Default RE: Access DB

    It depends on whether you need to keep the data in the table or not.<BR><BR>If not:<BR>1) Empty all the tables<BR>2) Do a Repair & Compact<BR><BR>If you do need to keep the data:<BR>1) Create copies of the Table structures<BR>2) Append the existing data into the empty tables<BR>3) Delete the original tables<BR>4) Rename the copied tables to the original names

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts