Hi Patty,
I know the issue was random but was trying to see if, in its randomness, the issue happened after the initial use of the database and not upon opening it for the first time in a day. The intent is to see if the possible cause is, similar to what Bill mentioned, but was possibly caused by abruptly closing Access without going through the normal, designed, close database steps. There are times when the Task Manager shows a process as being active even though it was thought to be closed and there's no tab in the Taskbar for the process or application. When this is the case, the Task Manager Applications Tab will not, for example, show Access as being active while the processes tab will show Access as being present.
This "Application not present but Process is" condition, at least for me, happens most often when an application seems to hang up and I need to force its closure. Another possibility could be a 32-bit app running on a 64-bit OS and it doesn't, for whatever reason, clean up after irself when closed so that the Process is still present.
Jeff
----- Original Message -----
Patty
Along with all the other advice, I'll add this: The user could inadvertently
opened the FE more than once. Next time it happens have the user call you so you
can prompt him/her to open the Task Manager and look under the Applications tab
to see if the FE is indeed open more than once.
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT http://thatlldoit.com/ > http://thatlldoit.com
MS Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E >
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My Nothing-to-do-with Access blog
http://wrmosca.wordpress.com > http://wrmosca.wordpress.com
From: MS_Access_Professionals@yahoogroups.com
[mailto: MS_Access_Professionals@yahoogroups.com ] On Behalf Of patrinod
Sent: Thursday, February 28, 2013 8:31 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Cannot use S:\thefile.mdb file already in use
Thanks for the quick response Jeff
The problem was report as random, but now I can ask a few questions and maybe
get a better idea of what is going on.
Re - turning Access off softly
I'm not 100% sure what you mean by this.
??? using the Exit Application button on the menu or clicking the X (close)
button on the top right corner of the window
--- In MS_Access_Professionals@yahoogroups.com
, Jeff Jones wrote:
>
> 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@...
>
>
>
>
> [Non-text portions of this message have been removed]
>
[Non-text portions of this message have been removed]
--
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 (15) |
Tidak ada komentar:
Posting Komentar