cannot update error

  • Thread starter Thread starter Dan Layten
  • Start date Start date
D

Dan Layten

I am currently developing a database for 2 users. It is a very simple
database with 1 table, and 1 form that users will use to enter data into the
table. The database is currently not split, just copied to a shared drive,
where the users open and and access the form to enter data. Things seem to
work some of the time, but frequently, users will get a , "cannot update,
record locked error". My question is, will splitting the database prevent
that, and is there any other measures I can take to prevent that error.

Thanks
 
I am currently developing a database for 2 users. It is a very simple
database with 1 table, and 1 form that users will use to enter data into the
table. The database is  currently not split, just copied to a shared drive,
where the users open and and access the form to enter data. Things seem to
work some of the time, but frequently, users will get a , "cannot update,
record locked error". My question is, will splitting the database prevent
that, and is there any other measures I can take to prevent that error.

Thanks
Click to expand...

Yes. Leave the non-static tables in the backend and everything else
goes into the front end. Distribute the copies to all the users.
 
Back
Top