Couldn't update; Currently locked. etc

[Daniel Kaseman]

I work for a company that uses 1 database for 5 users.

Ocassionally, while entering data into the talbes, one of us will get the
message on the screen:

"Couldn't update; currently locked."

What does this mean? How do we prevent it?

Also, we get a message called: "Disk or Network error."

Should we use linked tables?

There are no forms in the database, only tables.

Thank you in advance for your assistance.

Daniel

 

[Rick B]

First, you should not be entering data into a table, you should be using a
form.

Secondly, you should split the database into back-end (containing all your
tables and residing on the server) and front-end (containing your data entry
forms, queries, and reports.) The front-end should have the tables from the
back-end linked. Each user should have their own copy of the front-end on
their PC.

One other thing to check is windows file permissions. Each user will need
full permission (write, delete, modify) to the folder in which your database
lives. If they do not have full permissions, you will run into problems
trying to share it with more than one user.

 

[Daniel Kaseman]

Thank you, Rick

However, what difference does it make if we enter data into the tables
directly, vs. using bound forms? aren't bound forms virtually the same
thing as entering data directly into the table, only using a more graphical
user interface?

Daniel