My Acces 2003 database is used simultaneously by several people, but it is
not split (I know, I know!). Could this be the reason for Error 3709 which
happens when a user is editing a record via a form and the record suddenly
corrupts to show rubbish data? After this, you cannot edit or delete the
record any more.
I suspect this happens when one user is editing a record which then gets
called by a select query being executed by another user. Am I right? This
error started occuring recently, since I added several options to the
switchboard that run macros to execute multiple select queries.
Is splitting the database the answer? If not, any other suggestions, please?
Thanks.
Ewa
|
Similar Threads
