opening exclusive when shared is identified in options

  • Thread starter Thread starter Christa
  • Start date Start date
C

Christa

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.
 
Christa said:
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.
Click to expand...

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
 
Back
Top