Two computers writing a new record at the same time

[dendic]

I have several people creating new records to the same table at the same time. The new record is created by code the ADDNEW and UPDATE commands. Once in a while I get corruption where if I try to open the table manually I get an error message stating a record has been deleted and can't be opened. I then do a repair and the record that was the problem has several fields with ############# in them. I then delete that record and all is OK. Any suggestions on what can cause this problem. My default record locking is set to edited record. Maybe there is a way in code to check if a table is being edited then I can wait until it's complete before writing the next record?

 

[Remou]

Databases should be split into front end and back end. You may wish to read this:

http://www.granite.ab.ca/access/corruption/causes.htm

 

[dendic]

It is split

 

[Remou]

Well that eliminates the most common problem, perhaps it could be one of the others listed in the link?

 

[MichaelRed]

search the faqs re autonumber and why to NOT use them.



MichaelRed