autonumber assigning duplicate values ?

[Lavey]

I have a table with 11,000 + records that is multiuser...
it has a primary key named BatchID, this is an autonumber.

Just recently the autonumber field has been assinging duplicate values to new entries to the table...

Any ideas on how i stop this?
(btw - record locking is default)

Thx,

 

[cp950]

I am getting the same problem, now. It happens occasionally and erratically. Invariably, there are mostly oriental and non-sensical characters in these duplicate records.

Did anyone effectively resolve/prevent this?

 

[MichaelRed]

see faq700-184

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[JeremyNYC]

CP,

You've clearly got a corrupted database. This may be caused by a bad network connection or some other thing. A healthy database will not generate duplicate autonumber values. Check into corruption on the web and see what you can do to make your database healthy.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.

 

[Lavey]

FAQ Link dead:

You have requested an area that is currently undefined. Please hit the back button to go back. ____________________________________
Stop Animal Testing

 

[MichaelRed]

? Faq link dead ? Works for me. Did you LEFT click it?

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[MichaelRed]

JeremyNYC?

I think this is where I came in. Despite your continued and continuing disbelief, the AutoNumber in the multiuser situation can CAUSE the 'corruption' and other errors. Yes, it can (often / usually) be 'repaired' - but the repair does not find (or "REPAIR&quot the root cause which generates the corruption.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places