Thanks guys,
I have changed the locking to 'edited record' and that seems to be preventing the users from accessing the same record at the same time.
I will now have a look at splitting the database.
Cheers! Jason
Hiya,
The database isn't split into Front and Back end.
We have discovered that it seems to be a multi-user issue - when two users try to access the same record at the same time, it corrupts. The affected table also has an autonumber field in it - don't know if that's relevant.
In Options -...
Hello,
Our simple Access 97 database worked fine for years until we upgraded it to 2003. Now we regularly get corrupt records in the main table - either #error in every field, or random characters often in Japanese?! Grrrrr!
It's shared by 4 users on a Windows 2003 server, and is only 5mb in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.