Enable Multiple Users on Access DB

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.
 
D

Douglas J. Steele

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.
 
J

Jeff Boyce

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
 
G

gabry.morelli

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:
 
Top