Access 2007
(1)
Database
(1)
Directory
(1)

opening exclusive when shared is identified in options

Asked By Christa
19-Nov-09 11:48 AM
I have 2 users working with Access 2007.  Both have the Access Options marked
to open database as shared.  Both can open the database, but when they try to
run queries they get a message that it is opened exclusively by someone else.
Both are members of the same permissions group as far as the directory in
which the database is located.

Thanks.

Two or more users should not share the same file.

Keith Wilby replied to Christa
19-Nov-09 12:01 PM
Two or more users should not share the same file.  Split your database and
give each user their own copy of the front end.  More info here:

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

Keith.
www.keithwilby.co.uk
Post Question To EggHeadCafe