Multi-user

  • Thread starter Thread starter Bryan Brassell
  • Start date Start date
B

Bryan Brassell

I have a db on a network drive. There is a form for
updating information. It appears multiple users can open
the db and the form at the same time without any error
message (as would occur with 'read-only' in an Excel
file).

If multiple people on the network open this form and make
entries at the same time, will the table be updated
properly?

Regards,

Bryan Brassell
 
Bryan said:
I have a db on a network drive. There is a form for
updating information. It appears multiple users can open
the db and the form at the same time without any error
message (as would occur with 'read-only' in an Excel
file).

If multiple people on the network open this form and make
entries at the same time, will the table be updated
properly?

Regards,

Bryan Brassell
Click to expand...


For Access to work properly in a multi-user environment, you should
split (Tools > Add-ins > Database Splitter) the tables off and store
them on the Server as a 'back-end' file. Then distribute a copy of the
'Front-end' to each user's machine for them to run.

The answer to your question is 'Yes' but do split the database or you
are asking for trouble!

hth

Hugh
 
Back
Top