Move Access from TST to PRD

[Tausif]

Hi,

I have just developed my new application at the test system. Now I have to
move it to production.

During software testing testers have inserted lot of records into different
tables. I have deleted all the test records.

The problem is, when I moved the db to production, the PKey with AutoNumber
starts not from 1 but some big number like 1212 and etc.

How can I reset this autonumber?

THankx.

Tausif

 

[Guest]

The number will reset to 1 if you delete all records from a table and do a
compact and repair (Tools > Database Utilities... > Compact and Repair
Database).


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

I have tried several times to reset the counter and had no luck changing the
autonumber. Please post if [delete] and [compact and repair] work; I need to
do it also.
You can also set compact and repair on auto [click [options] [general tab]
place a check mark on compact on close.
I might try going back into form design mode and removing the counter and
then replaceing it into the form again like a brand new counter? Maybe that
might work

 

[Guest]

Sunday,

If you delete all records from a table, and compact the database, your
autonumber should start at 1 assuming you have the default setting for
increment (versus randomize) for the autonumber. If you have any records in
the table, then the next number assigned will be one higher than the highest
number in the database.

As far as I know, the only exception to this would be if you have not
updated your copy of the JET database engine. Here is a KB article that
discusses this:

BUG: AutoNumber field is not reset after you compact an Access database
http://support.microsoft.com/?id=287756

The resolution that you should follow is not shown in the above KB article.
You really should update the JET database engine to the latest service pack.
Here is another KB article that provides guidance on how to update your
operating system, Office, and the JET database engine:

How to keep a Jet 4.0 database in top working condition
http://support.microsoft.com/?id=303528


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________