Automated Number Field still dupes previous values after jet4.0 sp

[Esso]

I have a access database, that duplicates the automated number field. As in
article 257408.
I have downloaded and installed the latest service pack pack (8) for the Jet
database 4.0 but the automated number field still duplicates a previous value.

This is running Office 2000 service pack3 with all the office updates applied.

Can anyone help with this one?

TIA

 

[John Vinson]

I have a access database, that duplicates the automated number field. As in
article 257408.
I have downloaded and installed the latest service pack pack (8) for the Jet
database 4.0 but the automated number field still duplicates a previous value.

This is running Office 2000 service pack3 with all the office updates applied.

Can anyone help with this one?

TIA

I'm not certain that it will cure the problem, but the first thing I'd
try is to create a new, empty database (new backend if the database is
split); use File... Get External Data... Import to import all of the
tables from this one. Be sure to check the option to import
relationships. If you have security implemented, you may need to reset
the security on the tables. Compact the resulting database when you're
done.

This will give you a clean new set of systems tables which should - I
hope - fix the autonumber issue.

John W. Vinson[MVP]