Multiple Users on an 2003 Access Database

G

Guest

I have set up an Access 2003 Database.
Multiple Users will have to be able to work on this database at the same time.
(i.e. two users can create a query on the one table at the same time).

I have done the above in the past on existing databases however I have never
set
one up from scratch.

I would appreciate any assistance.

Thanks,

Alan.
 
J

Joan Wild

The usual method is to split your mdb. Put the backend (just the tables) on
a server, and give each user a copy of the frontend (all other objects) mdb
which would have linked tables to the backend.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple Users entering data at same time 16
2007 users cannot open secured 2003 database 2
Users Locked out of Shared Databases 10
Users in Access 2007 2
Need Multiple Users/Permissions Suggestions 4
Secure Access Database 1
Multiple Users - Update capacity 2
Concurrent Users 1

Top