I am running Access 97 over a network with (12) users. Tables in backend of a server.Is there any reason why my database would be missing records? We have about 32,000 records on a table called jobs. It has a 1:M relationship with (3) other tables (Delivery dockets, Job Sales Charges, Job Charges) based on JobID as primary key. But we seem to have a few records missing from the Job table. Is it possible a autonumber is not generated when (2) users try to enter a record at the same time. Is there a quirk in Access 97 that at time skips generating an autonumber? Any help on this subject would be greatly appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Missing records or autonumbers
- Thread starter ssatech
- Start date
MichaelRed
Programmer
see the ubiquitous {F1} (a.k.a. HELP). It can be helpful for low level information like you are seeking. See faq700-184 for (a rather more elaborate) scheme to generate unique Primary Key values for a multiuser recordset.
MichaelRed
m.red@att.net
Searching for employment in all the wrong places
MichaelRed
m.red@att.net
Searching for employment in all the wrong places
Dear ssatech,
Yes, there is a 'quirk' in access that will make 'AutoNumbers' appear like they are missing.
Whenever a user or program begins to create a new record, the 'AutoNumber' is generated. If the new record is then canceled(Undo), well, the next autonumber is generated as if the 'Canceled' record were saved.
You can test this.
1) Create a test table with a couple of fields, make one of the fields an autonumber.
2) Just open the test table and add a couple of test records.
3) Now, go to the last line (Blank/new) and begin to add a couple of the fields.
4) Instead of moving off the record, press 'escape' to cancel the add of the new record.
5) Now add another record and see what the 'AutoNumber' is!
Hope This Helps,
Hap...![[2thumbsup]](/data/assets/smilies/2thumbsup.gif "[2thumbsup] [2thumbsup]")
Access Developer![[pc]](/data/assets/smilies/pc.gif "[pc] [pc]")
Access based Add-on Solutions
Access Consultants forum
Yes, there is a 'quirk' in access that will make 'AutoNumbers' appear like they are missing.
Whenever a user or program begins to create a new record, the 'AutoNumber' is generated. If the new record is then canceled(Undo), well, the next autonumber is generated as if the 'Canceled' record were saved.
You can test this.
1) Create a test table with a couple of fields, make one of the fields an autonumber.
2) Just open the test table and add a couple of test records.
3) Now, go to the last line (Blank/new) and begin to add a couple of the fields.
4) Instead of moving off the record, press 'escape' to cancel the add of the new record.
5) Now add another record and see what the 'AutoNumber' is!
Hope This Helps,
Hap...
Access Developer
Access based Add-on SolutionsAccess Consultants forum
ssatech,
I've responded to this question so many times I just put up a web page about it. Check the Developers' section on my website, below.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
I've responded to this question so many times I just put up a web page about it. Check the Developers' section on my website, below.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
- Thread starter
- #5
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
