Multiple users

[Rodrigo Borges]

Is it possible to put the mdb file on a shared folder and allow some users
to edit it? Does Access work with that?

I really need it, even for read only....

tks

 

[Douglas J. Steele]

Yes, Access is multi-user right out of the box.

The preferred method for sharing, though, 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.

 

[Rodrigo Borges]

and how can I do this split? I have already a single file will all objects
(tables, relationship, queries, forms, etc)....

 

[Douglas J. Steele]

Check what Tony Toews has at
http://www.granite.ab.ca/access/splitapp/index.htm