Release .mdb that is in use by another file

[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?

 

[Nick Coe \(UK\)]

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?

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]

I cant open the "destination".mdb to compact it - and I
cant delete the .ldb file...

 

[Nick Coe \(UK\)]

I cant open the "destination".mdb to compact it - and I
cant delete the .ldb file...

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
----

 

[carrie]

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

 

[Guest]

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

 

[Nick Coe \(UK\)]

2000

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
----