I have a user that is somehow managing to open multiple copies of a
single Access database. We are using Access 2003 and everything I have
tried makes it IMPOSSIBLE to open the same database more than once.
This database runs code on the execution to look into a master database
for new changes and will update the user's database accordingly. I
think I have narrowed it down to when the user is being updated, she
runs into this issue. I can't get her to explain what she is doing to
cause this because she doesn't know she is doing it.
I realize that my master database is locked up and go over to her desk
and she can have 2 sometimes 3 instances of the database open with
error messages displayed. I have about 20 other users using a copy of
the exact same front end and no one else has this problem. When I try
to recreate the scenario the already opened database maximizes as
opposed to a second instance opening, which is what should happen. Has
anyone ever run into this problem and do you have any idea what this
user is doing to possibly cause this?
Thanks!