Locking Files

  • Thread starter Thread starter Barb
  • Start date Start date
B

Barb

I am rewording my question as I may not have made it clear
last night.

My problem is when exiting a database in 2002 the .ldb
file is not being deleted therefore making the database
unavailable for exclusive use. Restarting the computer
deletes the file and allows me to continue.
Do you know what i can do to rectify this?
I have A2000 installed on the machine but am using 2002.

Thanks for any help you are able to provide.
Barb
 
Barb said:
I am rewording my question as I may not have made it clear
last night.

My problem is when exiting a database in 2002 the .ldb
file is not being deleted therefore making the database
unavailable for exclusive use. Restarting the computer
deletes the file and allows me to continue.
Do you know what i can do to rectify this?
I have A2000 installed on the machine but am using 2002.

Thanks for any help you are able to provide.
Barb
Click to expand...

Do you *have* to restart the computer to get rid of the lock file? Can
you manually delete it instead, or does that give you a message about a
sharing violation?

If you can manually delete the file without restarting, it may be that
you don't have delete permissions on the folder in which the file was
created. However, that seems very unlikely unless this folder is on a
network share, not your own hard disk.

If you can't manually delete the file until you restart your computer,
it may be that Access is actually not sutting down all the way, but
instead is still running. You can press Ctrl+Alt+Delete to bring up the
task manager and see if the MSACCESS.EXE process is still running.
There are several bugs, as well as programming errors you can make, that
can cause this. You say you're running Access 2002. What OS are you
running it under?
 
Thanks for your reply Dirk. I am running Windows 2000.
No I can't delete the file - i get the sharing violation
error. I cannot open the database from the shortcut, but
if i open it from within Access i can access it but not
exclusively. Any further ideas? What sort of bugs are
you referring to?
Thanks, Barb
 
Thanks for your reply Dirk. I am running Windows 2000.
No I can't delete the file - i get the sharing violation
error. I cannot open the database from the shortcut, but
if i open it from within Access i can access it but not
exclusively. Any further ideas? What sort of bugs are
you referring to?
Thanks, Barb
Click to expand...

It sure sounds like Access isn't actually closing. Did you try checking
the task manager as I suggested?

As for bugs, the first one that comes to mind for Access 2002 is one
that I have personally documented, which is associated with conditional
formatting applied to a calculated control. After displaying a form
with conditional formatting applied to a calculated control using the
"Field Value Is", "equal to" option, MSACESS.EXE remains in memory
(shown in task manager's list of processes) even after both the form and
application are closed. If this is the bug that's biting you, I am told
that it has been corrected by SP3. So go to the Office Update site,

http://office.microsoft.com/officeupdate/default.aspx

and make sure that your copy of Access 2002 is completely up to date.

Among other bugs that can cause this problem are the ones documented in
this article:

http://www.mvps.org/access/bugs/bugs0005.htm

Although the "boolean bug" is mentioned in the article only with respect
to Access 97, I don't guarantee that it doesn't exist in later versions.

I've also seen Access refuse to close when you have a global object,
like a database or recordset object declared at module level in a
standard module, that is not set to Nothing before you try to exit.
 
It may well be the recordset issue - i am using rst.close
rather than setting the recordset to nothing. I have
tried to set it to nothing but obviously have the wrong
syntax - rst = Nothing gives me the error "invalid use
of property". What am i missing???
Thanks Dirk
 
set rst = nothing

HTH,
TC


Barb said:
It may well be the recordset issue - i am using rst.close
rather than setting the recordset to nothing. I have
tried to set it to nothing but obviously have the wrong
syntax - rst = Nothing gives me the error "invalid use
of property". What am i missing???
Thanks Dirk
Click to expand...
 
Back
Top