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]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (14) |
Tidak ada komentar:
Posting Komentar