By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,650 Members | 1,823 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,650 IT Pros & Developers. It's quick & easy.

Opening Multiple Copies of one Access Database

P: n/a
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!

May 23 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You can easily open as many occurence of MS Access software as your computer
memory will allow. So having said that, what appears to be happening to me
is your end user opens up the database using the MS Access software and then
selecting the database. Again they open another occurrence of MS Access and
open another occurence of the same database. Check it out. It will not occur
if the user is in MS Access and then attempts to open another database but
as long as they open the MS Access software they can open the same database
over and over....hope this helps

"jritacco" <je**************@vercuity.com> wrote in message
news:11*********************@u72g2000cwu.googlegro ups.com...
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!

May 23 '06 #2

P: n/a
Thanks for the suggestion. I see what you are saying. You can execute
MS Access and open the db multiple times. I would be really surprised
if the user even knows how to do this but I will look into it. I
really believe she is somehow opening the multiple instances by using
the icon on her desktop but I will find out.
Thanks again!

May 24 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.