Release .mdb that is in use by another file

  • Thread starter Thread starter Carrie
  • Start date Start date
C

Carrie

I am working on a VBA program ("source") that modifies a
table in another .mdb file ("destination").

While debugging my code, my "source" fails and I stop
execution. This however leaves "destination" in a locked
state as "opened exclusively by another user".

Right now I reboot my PC to free "destination".

Is there a way of releasing the "destination" .mdb?
 
Carrie said:
I am working on a VBA program ("source") that modifies a
table in another .mdb file ("destination").

While debugging my code, my "source" fails and I stop
execution. This however leaves "destination" in a locked
state as "opened exclusively by another user".

Right now I reboot my PC to free "destination".

Is there a way of releasing the "destination" .mdb?
Click to expand...

First of all run Compact + Repair on 'destination'. If that
doesn't work look for a file in 'destination' directory with
the same name as destination but the suffix .ldb. This is
the Jet locking file for that mdb. Delete it. Run Compact +
Repair on 'destination' again.

Failing that get Jetcomp.exe from Microsoft downloads and
try that.


--
Nick Coe (UK)
AccHelp v1.01 Access Application Help File Builder
http://www.alphacos.co.uk/
Download Free Copy
----
 
Carrie said:
I cant open the "destination".mdb to compact it - and I
cant delete the .ldb file...
Click to expand...

What operating system?

If Xp Pro, 2000 or NT do you have appropriate permissions?

There is also something about WinXP not permitting deletion
of certain files on the MS Support web site but I can't find
the URL...


--
Nick Coe (UK)
AccHelp v1.01 Access Application Help File Builder
http://www.alphacos.co.uk/
Download Free Copy
----
 
2000
-----Original Message-----


What operating system?

If Xp Pro, 2000 or NT do you have appropriate permissions?

There is also something about WinXP not permitting deletion
of certain files on the MS Support web site but I can't find
the URL...


--
Nick Coe (UK)
AccHelp v1.01 Access Application Help File Builder
http://www.alphacos.co.uk/
Download Free Copy
Click to expand...
 
Process Explorer from www.sysinternals.com allows you to free locked
resources without rebooting.
Perhaps you should consider a disconnecting function that you always run
when done debugging before killing the VBA session.

madhouse
 
carrie said:
2000
Click to expand...

http://www.granite.ab.ca/access/corruptmdbs.htm

http://support.microsoft.com/default.aspx?scid=kb;en-us;299373

A97 but still appropriate
http://support.microsoft.com/default.aspx?scid=kb;en-us;308633

http://support.microsoft.com/default.aspx?scid=kb;en-us;247771

http://members.iinet.net.au/~allenbrowne/ser-47.html

I've been trying to find anything in MS support about the
inability to delete certain file suffixes without much
success. If none of the links above help then suggest you
repost.

Good luck.

--
Nick Coe (UK)
AccHelp v1.01 Access Application Help File Builder
http://www.alphacos.co.uk/
Download Free Copy
----
 
Back
Top