Enable Multiple Users on Access DB

  • Thread starter Thread starter gabry.morelli
  • Start date Start date
G

gabry.morelli

Hi everybody,

my company has an issue and I have to solve it. I have to create a
multiple users application, its basically a form that stores data on
just one database table.
To make it faster i wanted to use MS Access because they need it really
fast.
How do I enable access 2003 to multiple user?

Thanks for any help.
 
Access is multi-user out of the box.

Some advice, though. The appropriate way to design multi-user applications
is to split the application into a front-end (containing the queries, forms,
reports, macros and modules), linked to a back-end (containing the tables
and relationships). Only the back-end should be put on the server: each user
should have his/her own copy of the front-end, ideally on his/her hard
drive.

And each user requires RWXD (Read, Write, eXecute and Delete) permissions on
the folder where the MDB file exists, even if they're only read-only users.
This is because when the first user connects to the database, a locking file
(.LDB) is created in the folder. Subsequent users update that file, and the
file gets deleted when the last user disconnects from the database.
 
You're done. Access, out of the box, allows that.

You will need to put the data some place that everyone can see (on a network
share). This is called the "back-end", and only has data/table(s) in it.

You will need to create another Access .mdb file. Use File | Get External
Data | Link... to connect to the back-end table(s). Add your forms,
reports, queries, etc. in this second Access database file. This is called
the "front-end", and has only "links" to the data/table(s).

Now put a copy of the front-end on each user's PC.

(By the way, if you haven't used Access before, it has a steep learning
curve. Being able to do the above is fairly simple. Creating a
user-friendly front-end that prevents the users from accidentally messing up
is MUCH more work ... "Easy", ... is HARD!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Thanks Douglas for the tip,
In a few words I have to use just MDB files and put a link to the table
inside the back-end file?


Douglas J. Steele ha scritto:
 
Back
Top