Cannot open second copy of Access 2003 database

1340 pts.
Tags:
Microsoft Access
Microsoft Access 2003
I have created several databases that we use it the office. They are kept on a server. Recently, we started getting a security warning window everytime we open Access. It asks DO YOU WANT TO OPEN THIS FILE? and points out that the publisher is UNKNOWN PUBLISHER. If you click yes, it opens normally. However, from about that same time, we realized that we are not able to open a second copy of any of the databases. If someone else has a database open and I try to open it also, I do not get any error message, but it just ignores the opening click. I do not know if theses two changes to the way Access is operating are connected or not. IT does not think they did anything that would have triggered this. I am wondering if it is a trust issue, either between the individual computers or between our server and ITs server. I created a small, clean one table, one record database and stored it on my C drive. It operated normally. Then I copied it into the database folder on our server and got the new behavior.

Answer Wiki

Thanks. We'll let you know when a new response is added.

I feel there is a default setting change when you are migrating to a server. When you open the database – click the “open” button (with downward arrow). There will be options like: Open, Open Read-only, Open exclusive, etc. Select Open Read-only. If it works then it means the server is enforcing single updates (.ldb). There are some settings to enforce multi-user updates on shared database. I do not access to Access 2003 (have Access 2007). Hopefully these is the way Access 2003 behaves. Will be ineteresed to know the final solution. Good luck.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • tlsanders1
    You led me to another piece of the puzzle, but I don't know what it means. The way I normally open a database is to open a Windows window which contains the database file, then double click on the file. That's when I get the security warning. If I do that while someone (even myself) has the database open and there is an .ldb file, which I think tracks record locking info, the double click refuses to work. After your answer, I first opened Access and used the File, Open buttons to get an File Open window. From there, any of the opening methods works fine to open the database. For instance I can double click the file icon from inside that File Open window, and the database opens without the security warning. While it is open, I can open another instance of Access and do the whole thing again and get a second copy of the database open. So, it seems that my issue stems from the method of trying to open the file by double clicking the file and having it open Access as it opens. Got any guidance on what that means? Thanks for pointing me a way to get multiple copies of the database open.
    1,340 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following