Link to home
Start Free TrialLog in
Avatar of anAppBuilder
anAppBuilderFlag for United States of America

asked on

Does auto-increment work reliably in Access 2010?

In Access 2003 and 2007 auto-incremnt numbers can become corrupted.  See http://allenbrowne.com/ser-40.html and
http://support.microsoft.com/?id=884185

Can anyone tell me whether this has been fixed in Access 2010?   Is there an authoritative document, preferably from Microsoft, that tells whether this has been fixed?

Thanks!
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Auto Numbers are a fact of life in Access database design, and have for the most part .... 99.99999999 % been extremely reliable since Access 1.0.

I would have zero fear of using Auto Numbers.

mx
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of anAppBuilder

ASKER

thank you all
Thank you!