multi users

J

John

I had one person enter data in a table and I want to create a new form and
it would not let me because some one had the database open I was not even
using the same table. Is there a way around this error message?
 
D

Damien McBain

John said:
I had one person enter data in a table and I want to create a new
form and it would not let me because some one had the database open I
was not even using the same table. Is there a way around this error
message?
Click to expand...

You must have the database open exclusively to make changes.

Split the database into a back-end (tables) and front end (everything else).
You can do this automatically with the database splitter in the tools menu.

Then give the other users their own copy of the front end. Make sure the
tables are linked to a network location which is going to be the same on all
the client machines.

You can then make changes to your copy of the front end as you please and
distribute new versions when you need to.
 
Top