Sharing the Database with Multiple Users at One Time

S

Sylvia

Is it possible to share one database with multiple users at one time? I sort
of thought this was part of the point of a database...I created several on my
company's shared network, but when I am in the databases, others can't access
them. What am I missing here?

Thanks.
 
R

Ryan

You may be openening the database exclusively. In this case the first user
to open the database will be the only user able to open it. To change this,
open your database, go to tools, then options, then advanced. Change the
default open mode to shared instead of exclusive.
 
G

Golfinray

Yes. You need to split the database. When you split the database, that means
you would have a frontend file (FE) and a backend file (BE.) Normally, the BE
file goes on your LAN. The FE file will go on each users computer. The BE
file contains the tables. The FE file contains the queries, forms, and
reports. The users must have read/write/edit/and delete rights to the BE file
AND the folder it resides in. For a thorough explaination, see Joan Wild's
comments at www.jmwild.com or google Albert Kallal. On his web site is an
excellent explaination.
 

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

Sharing an Access Database on a network 2
Newbie ? using multiple users in one database at same time 9
Database with Multiple Users 3
Multiple users of same database? 1
Access Database SharePoint and Protection 2
Access 2003 subforms 1
Sharing a Access Database 2
Make Access database available to multiple users on a network? 11

Top