Question You do not have exclusive access to the database at this time. If you proceed to make

[mishrahv]

Explanation of Issue:
-----------------------
We have 5 users using one ACCESS Databas and the application is in same package of database, I mean there is a file .accdb extension and this file holds application and ACCESS database both.

This file resides on Network Drive and all users have short cut link to access it. There was no issue or errors when users had there client laptop with Windows XP.

After there client is upgraded to Windows 7, they start getting the error message as:

"You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later."

Can any one help me, why was it working before and how come it start giving this irritative message.

Also the message appears atleast for 20 times...

Thanks

Raj

 

[boblarson]

This database should be SPLIT to a Backend (tables only and on a server) and Frontend (everything else and a copy of it on EACH user's machine).

Design changes can't be made while someone is in the database. So that is why the message comes up. However, users should NOT be making design changes in the database. With the split database you would make changes in the master frontend copy and then redistribute the frontend to each user (you can also use an auto updater like I have for free on my website).

 

[mishrahv]

Thanks for reply.

I did the SPLIT and Application was copied to each users C: Drive. But now after splitting i see some other issue:

Issue description:
--------------------
One of the Daily Task that users do is, export the data from ACCESS Application into the Excel Sheet and then they make changes in that Excel Sheet.
Once the changes are done, they import it back.

Now strange thing is, when they import back the Excel, it only reflects in that users application. Other users are not able to see that changes. I was surprise. so what i did, I tried to open the database directly to see if this changes are appearing there, but strange the changes were not in database and they were only appear to the user application in C Drive who had imported excel sheet. And off course other users cannot see that.

Not sure, why changes are not saved in database after importing the excel sheet into the Access Database. Any idea?

Thanks
Raj

 

[boblarson]

It sounds like their frontend is not linked to the same backend file. You might check that by going to Linked Table Manager from their frontend and verify that the links to the backend tables show the correct path. You can even relink them just to be safe (remember to check the box ALWAYS PROMPT FOR NEW LOCATION when relinking so it lets you navigate to the path).

 

[mishrahv]

Hi,

I tried to link that but still the changes does not show either opening the database or opening the other users application.

Would you like to do remote session, if you have some time?

Thanks

Raj

 

[mishrahv]

Hi,

The issue is resolved. Actually after importing the excel sheet from application, i was missing one step and that is:

1) Give right click on that imported excel sheet, and select "Export' and then "Access", it will ask you to show the location of Database in Browser Window, go to the database location and select the database. And here you go..... all the data is imported now into Access Database and all users can see that data now...

Thanks

Raj

 

[boblarson]

Glad you got it solved.

 

[theKruser]

Bob-

I am having the same issue. I have split my database. The BE resides on a network drive. I have it linked by the network path, not drive letter. The FE for users is an accde, while I maintain the only accdb FE. I have your Auto Updater installed (an excellent tool, by the way -- I use it in all of my databases). Everything works fine with one person connected to the BE. After that, all others (inbcluding me) get the following error:

The Microsoft Office Access database engine cannot open or write to the file '**network path**'. It is already opened exclusely by another user, or you need permission to view and write its data.

All of the computers that access the BE are right next to each other, so I can view them all at the same time. None of the users are opening the BE. They are all opening the accde from their desktop.

For some reason, the FE -- it seems -- is opening the BE exclusively. I do not know how that is possible. Any ideas?

Thanks in advance for your help.

 

[boblarson]

Make sure ALL users have read/write/delete rights to the folder that the backend resides in. If one user who has no write or delete rights opens the db first, then it will lock it as read-only.

 

[theKruser]

I checked that. All users are set to full control. I am currently having some issues with then number of connections my computer will allow. The BE is on a external HDD on my computer and others are connecting to it. We are getting errors that say the maximum number of connections has been reached and people are getting denied access. Would that cause this issue?As a side note, I know this is not the most desirable setup, but it is the only one possible at this time. We are working on trying to increase the nyumber of connections that Windows will allow...but that is a question for another forum (unless you have the answer, of course).

 

[boblarson]

That would be a problem. You don't have a file server to place the backend on?

 

[theKruser]

Unfortunately no...or I should say not yet.