Patty, I went through a flippin nightmare here with a similar situation. I got my intelligence insulted regularly because corporate IT would send me information regarding "exclusive access" stuff and other trite nonsense. I believe it was John Viescas? along with some google searches and corporate finally owing up to the fact that the back end tables were on NAS boxes and not regular servers that was the problem. See, I didn't have this problem until I ended up with a higher usage or at least it made the problem more salient. It felt before hand that the user was trying to put a lock on the same tables that it already had opened, but they clearly didn't open it twice etc. all this aggravation... I kept bothering corporate to give me event logs to show and when they said that they didn't have event logs because it was on an NAS box and John said that they had access lock problems with their NAS situation... well...
So..... I was finally able to move the back end tables over on to REAL windows severs and guess what? The problem went away. It was a wonderful coup.
Best of success.
Respectfully,
Liz Ravenwood
Programmer/Analyst
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jeff Jones
Sent: Thursday, February 28, 2013 8:12 AM
To: MS Access Professionals
Subject: Re: [MS_AccessPros] Cannot use S:\thefile.mdb file already in use
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]
------------------------------------
Yahoo! Groups Links
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (13) |
Tidak ada komentar:
Posting Komentar