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