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]

"Haas C" <haas.c...@gmail.com> wrote in message
news:7f8cf65b-3a0a-4308...@1g2000vbe.googlegroups.com...

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.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Haas C" wrote:

> .
>