cannot update error

[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

 

[Piet Linden]

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

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

 

[Stewart Berman]

Specify record locking for the table.