Multiple Users

[tobester]

Hi

I have created a simple enquiry database in Access 2003. Multiple users are
unable to open the database to enter their data. What do I need to do to
allow this?

Thank you!!
toby

 

[Douglas J. Steele]

Split the database into a front-end (containing the queries, forms, reports,
macros and modules), linked to a back-end (containing the tables and
relations).

Put the back-end on the server.

Give each user a copy of the front-end to put on their hard drive.

Make sure each user has a minimum of Read/Write/Create permission on the
folder where the back-end exists on the server. (It's usual to give them
Delete permission as well)