Access Database with more than 1 user. Please, need urgent advice.Thank You.

  • Thread starter Thread starter shapper
  • Start date Start date
S

shapper

Hello,

I have a Microsoft Access file in a network. Can I access the file
from multiple computers?
And can the users edit the database, using a form, at the same time?

Thanks,
Miguel
 
Yes, but the application needs to be split into front end (FE) and
back end (BE). You can use the Database Splitter to do this. The BE
will contain the tables and relationships and the FE will contain
everything else (queries, forms, reports, modules). The BE needs to
be in a shared folder on the network. All users should have
read/write/delete permissions for this folder. Each user should have
their *own* copy of the FE, preferably on their local drive. DO NOT
have multiple users share the same FE from the network.

When you split it, if you use UNC path naming to the BE ( as opposed
to drive letter path naming) it will simplify things when you distribute
the FE to the users. So the path would look like;

\\TheServer\TheFolder\YourBEFile.mdb

instead of;

S:\TheFolder\YourBEFile.mdb

You can find more info at;

http://www.granite.ab.ca/access/splitapp/index.htm
 
Hello,

I have a Microsoft Access file in a network. Can I access the file
from multiple computers?
Yes.

And can the users edit the database, using a form, at the same time?
Click to expand...

Yes.

However, for stability, better performance, and to avoid corruption, you
should split the database into a "Frontend" containing the Forms, Reports,
Queries etc., linked to a shared "Backend" containing only the tables. Each
user should have their own copy of the frontend.

See http://www.granite.ab.ca/access/splitapp.htm
 
Back
Top