Autonumber is creating numbers that are not unique.

[Jon]

I have created a table with an autonumber as a PK. I added about 186 records
to this table by copying and pasting from an excel sheet. The autonumber
increased for each record automatically as expected.

However, I have now tried to add a new record and the autonumber has come up
as 3, which is not unique and then tells me so as it tries to save the
record. Any ideas please??

 

[Jon]

Thank you chris. Before receiving your reply I compacted and repaired the
database and it solved the problem. Thanks for the link, I will use that if
it happens again.

Does windows update automatically get the updates for access? If not where
do I get the service packs you mention? How would I check to see if they are
already installed?

 

[Jon]

Thanks for the links Chris, I checked and I have the latest updates, I am
running office 2007 on windows vista SP1. So I guess the issue still exists!
Alt least the repair and compact sorted the probem.

Thank you for your replies

 

[Allen Browne]

Jon, here's a list of the causes for your issue:
http://allenbrowne.com/ser-40.html

The second one (appending data to a linked table), remains unfixed in A2007.

BTW, if you don't have SP1 for Office 2007, you really need it. The link is
here:
http://allenbrowne.com/Access2007.html
along with links to the hotfixes released since SP1.

And compacting is a good way to reset the AutoNum in most versions of
Access/JET.

 

[Jon]

Thanks Allen, I have SP1, i found it had been installed in the updates
installed list on windows update.

Thanks for the link to your site, I am in the 'others' scenario for sure.

I have a problem with a pop up modal form too, but i will start a new thread
about this, hop you might be able to look out for it.

 

[Tony Toews [MVP]]

Windows update doesn't automatically download updates for office applications.
Office update does that for Office XP and later.

Sorta. If you run Windows Update and switch to Microsoft Update then
that will also do the Office Update. Unless you're running Access
2003 runtime in which case you have to run Office Update to get those
updates or download and install SP3 yourself.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/