Search results

Ken, thanks for the input, I was not bothered about using it as a count, but I did not want to have a reference of 127205489 when there was only 9916 records. It suddenly happened, don't know why. Anyway I have sorted it out, I copied the data and structure to a new temp table, deleted...

Actually this does not work in my case!!! http://www.microsoft-accesssolutions.co.uk/reset_autonumber.htm Any other ideas?

Located some excellent instructions on this excellent forum on how to re-set the Auto-number, works perfectly, thnx. :D

Autonumber question Sorry to barge in on this thread, but as I have a related question! I have an Autonumber field that suddenly decided to start using numbers from 127205489 while my previous last record is 9916. I want to re-set it back to 9917, but do not know how. I tried compact and...

A related question Apologies for butting into this thread with my own question? I think I need to go through the security side of things on my database too, but this one got me tonight. I did a Compact and Repair on my main database, then I ran a macro in an excel sheet on my portable (p2p on...