Sharing an Access Database on a network

  • Thread starter Thread starter Haas C
  • Start date Start date
H

Haas C

Hi all!

I have Access 2003 and have created a database which I want to share
on our network. I have gone to Tools, and then Options, and then to
the Advanced tab. I designated the 'Default open mode' to be "Shared"
and selected "Edited record" for the 'Default record locking' option.
I've placed the database onour shared drive and if I open it up, no
one else can. I want multiple users to have the ability to open it at
the same time if needed - what am I doing wrong?

Thanks!
-Haas
 
Haas C said:
Hi all!

I have Access 2003 and have created a database which I want to share
on our network. I have gone to Tools, and then Options, and then to
the Advanced tab. I designated the 'Default open mode' to be "Shared"
and selected "Edited record" for the 'Default record locking' option.
I've placed the database onour shared drive and if I open it up, no
one else can. I want multiple users to have the ability to open it at
the same time if needed - what am I doing wrong?

Thanks!
-Haas
Click to expand...

Split the database and give each user their own front end. More info here:

http://www.granite.ab.ca/access/splitapp/index.htm

Keith.
www.keithwilby.co.uk
 
Also adding to what Keith said, all the users must have Read, Write, Create,
and Delete privileges to both the datebase .mdb file AND the entire folder
holding that file.
 
Back
Top