Microsoft Access
--
Questions
--
Followers
Top Experts
How can I not have exclusive access to my Access application on a single user non-netwroked machine.
I am working on an Access 2013 application on my stand alone Win 10 machine. This machine is not connected to a network and I am the only user.
If I open the database and make changes there is no issue. Everything is saved an no messages appear.
If at any point while I have the database open I run a test on some logic and then try to make revisions I get this message
After I get the message I have to reboot the machine to get the ability to revise the application back.
I am not having this issue in any of my other applications. I am definitely the only user on this machine.
I have been developing Access applications for almost 2 decades and have never encountered this situation before.
Any ideas what is going on?
If I open the database and make changes there is no issue. Everything is saved an no messages appear.
If at any point while I have the database open I run a test on some logic and then try to make revisions I get this message
After I get the message I have to reboot the machine to get the ability to revise the application back.
I am not having this issue in any of my other applications. I am definitely the only user on this machine.
I have been developing Access applications for almost 2 decades and have never encountered this situation before.
Any ideas what is going on?
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
Probably you closed the application and the lock file was left ...ldb,laccdb
Just ensure that Access is not running and delete the lock files and try again
Just ensure that Access is not running and delete the lock files and try again
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
As gustav said, it's whatever you are doing as part of the test.
From Access's standpoint, it see's more than one connection to the database, so it says that you do not have exclusive access.
One way to do that would be to open the same DB with two separate instances of Access. It doesn't care that they are running on the same machine and are by the same user. It only sees two connections to the database.
Jim.
From Access's standpoint, it see's more than one connection to the database, so it says that you do not have exclusive access.
One way to do that would be to open the same DB with two separate instances of Access. It doesn't care that they are running on the same machine and are by the same user. It only sees two connections to the database.
Jim.
And BTW, one of the reasons you may have never have hit this before is that this behavior was changed.
Up until Access 2000, the VBA project within the DB was not monolithic and it was possible for multiple users to make code changes at the same time.
Starting with Access 2000, that was no longer true. Now the VBA is monolithic and only one user at a time can make code changes.
Up until Access 2000, the VBA project within the DB was not monolithic and it was possible for multiple users to make code changes at the same time.
Starting with Access 2000, that was no longer true. Now the VBA is monolithic and only one user at a time can make code changes.
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
Thanks for your input. I still don't know exactly what was causing the issue.but I did revise the way I was testing and got through my changes. I don't have the luxury of time right now to play with this enough to pinpoint the cause but if I figure it out later I'll post the result.
Microsoft Access
--
Questions
--
Followers
Top Experts
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.