thomas610
asked on
Could not update; currently locked by user 'Admin' on machine "ServerA"
We run a PC at a remote location that is collecting data. The data is put into an MSAccess database.
On a regular basis we use a server (ServerA) in a different location to connect to the remote PC and using MS SQL we extract data from the MS Access database.
On the remote PC our application keeps and error log and occasionally we see the following message:
"Could not update; currently locked by user 'Admin' on machine "OurServerName"
If MSAccess is able to be used by multiple users, why do we get this message at times? Why is our server "locking" the remote database?
On a regular basis we use a server (ServerA) in a different location to connect to the remote PC and using MS SQL we extract data from the MS Access database.
On the remote PC our application keeps and error log and occasionally we see the following message:
"Could not update; currently locked by user 'Admin' on machine "OurServerName"
If MSAccess is able to be used by multiple users, why do we get this message at times? Why is our server "locking" the remote database?
Your users are either opening the db exclusively or you have record locking on that prevents record access. It is not the server but a user who has the db open and a lock on a table
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been abandoned and needs to be finalized.
You can accept an answer, split the points, or get a refund (information at http:/help/closing.jsp)
If you need a moderator to help you, post a question at Community Support (http:/Community_Support/)
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
walterecook
cleanup volunteer
You can accept an answer, split the points, or get a refund (information at http:/help/closing.jsp)
If you need a moderator to help you, post a question at Community Support (http:/Community_Support/)
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
walterecook
cleanup volunteer
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation in the Cleanup topic area for this question:
accept answer from 1William
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
walterecook
EE Cleanup Volunteer
I will leave the following recommendation in the Cleanup topic area for this question:
accept answer from 1William
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
walterecook
EE Cleanup Volunteer
ASKER
Didn't solve my issue but the Q has been open for so long - sorry I forgot about it. I will reopen the Q down the road. - thanks for the advice.