INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Your site is one of the cleanest and BEST forums that I have seen. I have sent quite a few people your way. Keep up the good work!!!"

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > DBMS Packages > Microsoft: Access Tables and Relationships > FAQs

Microsoft: Access Tables and Relationships FAQ

Troubleshooting

Why do I get duplicate Autonumbers after upgrading to Access 2000

faq700-2148

Posted: 8 Jul 02

Have you just upgraded from Access 97 to Access 2000?
Have your autonumbers reset in your tables?
The problem is that Access 2000 requires a patch in-order for it to compact a database without destroying it! The database gets compacted automatically when you convert the database from 97 to 2000 versions.

The Solution, get the patch from Microsoft.
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q257408

The other problem is that the database you have compacted is corrupt and isn't fixed with the patch. I haven't come up with a solution for this. I went back to an old version and then compacted with the patch in place.

Back to Microsoft: Access Tables and Relationships FAQ Index
Back to Microsoft: Access Tables and Relationships Forum

My Archive

My FAQ Archive