Missing records

[jaklits]

I have a problem that is driving me crazy. I created a database that is used by 2 or 3 people at the same time. I have the tables on a shared drive and the forms on there pc's. The database is used to create a new record containing various info that an individual enters for each job that is printed off our high speed laser printers. The problem is, if two people try to create a record at the same time, one does not get created, it looks as if it does but unfortunatly it doesn't. Please help, thanks.

 

[llkhoutx]

User collisions are uncommon but not unknown in Access. I suspect that that is what happening with your database.

Sometimes this is connected with two users simultaneously using the same record index (usually an autonumber). I've seen a solution whereby the index is created in a separate table and then used with the data table record.

Another solution with DAO writes is with Transmit/Commit/Rollback instructions which you can find in the Access Help menu.

 

[Pat Hartman]

Are you using an autonumber as your primary key or are you using something you generated?

 

[jaklits]

Yes I am using autonumber as my primary key.

 

[Pat Hartman]

1. Are you possitive the data is lost?
2. Have you looked at the tables directly, not through a query or form?
3. Have you made sure that there is no filter that is preventing the data from showing?
4. Could it just be that some extra autonumber id has been generated but no record created for it?

 

[jaklits]

The data is lost and I have no filters on. What I have noticed is when two people are creating a record at the same time the record number on the navigation button is the same for each one.
thanks for trying to help.
Also the autonumber isn't critcal to have.

 

[KeithB13]

Try moving your key field to another key field. Any unique feild will work. If you don't have one try using the Date() function instead of autonumber... I have had set up an automatic date field to record the exact time the user started entering the record.

Good luck,
Keith

 

[jaklits]

That seems to be working, I can't thank you all enough.