Patty,
Does it always happen on the second and subsequent times that the database is opened; or can it also happen the first time an attempt to open is initiated? If the issue occurs after the database has been opened and then closed, you might look into how the database is being closed. It could be that Access isn't being softly shut down.
Is the PC turned off at COB each day? If not, when the issue occurs, might try powering down the PC and turning it back on to see if that clears the lock.
Have you looked at the Task manager to see if Access is still loaded? If it is and the database can't be opened, having Access still open behind the scenes could cause this behavior.
Maybe.....
Jeff
----- Original Message -----
Has anyone experienced this problem?
One PC sometimes gets the message: Cannot use s:\thefile.mdb file already in use. This only happens every now and then.
The database is a FE/BE Access configuration
FE is an mde, BE is an mdb.
The FE is located on the user's machine.
The BE is located on our server.
The PC in question has full read/write privileges to the folder containing the BE.
Everyone else (about 15 users) do not have any problems using the application.
TIA,
Patty
--
Jeffrey Park Jones
Excel, Access, Word, Office Expert
Excel and Access, LLC®
http://ExcelAndAccess.Com
919-671-9870
5109 Deer Lake Trail
Wake Forest, NC 27587
jpjones23@centurylink.net
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (11) |
Tidak ada komentar:
Posting Komentar