sharing database

[Guest]

i want to share my database with my collegues at work. will it work if i
place it in a shared folder.or i have to do another things for it to work.
note that both of us will use the database at the same time and may use same
form also.

 

[Jeff Boyce]

Take a look at Access HELP (and check the tablesdbdesign newsgroup and
Google.com) concerning "splitting" a database.

The short version is that you will put an Access .mdb file with ONLY the
tables (i.e., the "back-end") on the network, and all the other objects (not
tables) in an Access .mdb file (the "front-end"), and link to the tables in
the back-end. You will put a copy of the front-end on each user's PC.

That way, each user will be using his/her own copy of the form.

You may need to modify your "record locking" settings if more than one
person is simultaneously trying to work on the same record, though.

Regards

Jeff Boyce
<Access MVP>