Corrupt records Error 3709 - will splitting the database help?

E

Ewa

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top