Sharing an Access Database on a network

[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

 

[Keith Wilby]

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

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

 

[Jerry Whittle]

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.