Multiple Access Users In one database

[Guest]

Hi, Everyone

I have a database that i have created for our collections team. Currently I
am the only one using the database, but i know if someone else tries to get
on the to database a message will appear stating that another user has access
to this database. The collections team has 4 team members and myself so there
will be 5 users accessing the database, how would i go about setting up the
database so that multiple users can use the database.

Thanks
Sheria

 

[Guest]

Hi,

Sound like you are opening the database exclusively.

Check 'Tools', 'Options', 'Advanced' tab, 'Default open mode', change this
to 'Shared'.

Regards,

Chris.

 

[Douglas J Steele]

First thing you should do is split the database 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 on
the server: each user should have his/her own copy of the front-end,
preferably on their hard drive.

Each user needs to have Read, Write, Delete and eXecute permissions on the
folder where the MDB file exists. This is because the first user to connect
to the database causes a locking file (.LDB) to be created in the same
folder as the .MDB file, subsequent users connecting update that file, and
the last user to disconnect from it causes the .LDB file to be deleted.

 

[Guest]

Thank you, I will give it a try

Hi,

Sound like you are opening the database exclusively.

Check 'Tools', 'Options', 'Advanced' tab, 'Default open mode', change this
to 'Shared'.

Regards,

Chris.

 

[Guest]

Thank you for your help,
If the database is split can changes still be made to the database.