Prev: Import a Text File
Next: calculate in form
From: Chi on 13 May 2010 12:44
Hi,

I am using the Access 2007 to create a database. It is almost done, but
somehow I get a message below.
_________________________________________________________

Could not use <name>; file already in use. (Error 3045)

The specified file is currently being used by another user or session. Wait
for the other user or session to finish working with the file, and then try
the operation again.
__________________________________________________________

The message appears when I select ENABLE THIS CONTENT option under OPTION
button of the SECURITY WARNING

I closed out the database completely, but I SOMETIME still get the message
when I open it again.

However, I can use the database if I ignore the message.

Please help

Thanks
Chi

From: Dirk Goldgar on 13 May 2010 15:37
"Chi" <Chi(a)discussions.microsoft.com> wrote in message
news:8CD23ADA-EC60-464A-A0AE-44A32BEDAD97(a)microsoft.com...
> Hi,
>
> I am using the Access 2007 to create a database. It is almost done, but
> somehow I get a message below.
> _________________________________________________________
>
> Could not use <name>; file already in use. (Error 3045)
>
> The specified file is currently being used by another user or session.
> Wait
> for the other user or session to finish working with the file, and then
> try
> the operation again.
> __________________________________________________________
>
> The message appears when I select ENABLE THIS CONTENT option under OPTION
> button of the SECURITY WARNING
>
> I closed out the database completely, but I SOMETIME still get the message
> when I open it again.
>
> However, I can use the database if I ignore the message.


Is the file on a network share, rather than your local PC? The only
reference to this message I've found so far is this KB article:

http://support.microsoft.com/kb/289681
You may receive a "file already in use" error message
when you try to open an Access database that is
located on a server

I don't know if that article is relevant to your situation or not.

--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

 | 
Pages: 1
Prev: Import a Text File
Next: calculate in form