asked on

How can I release a lock of an Access file?

Hi Experts,

I'm trying to create an ADE on the server and gettinng the msg "File is in use.." (See attached).
However when I check the server under manage open files, I see nobody have that file open.
Is there a way to release the lock without restarting the server?
Or if I can at least see who is posing the lock, that would also be of a help.

Thanks
untitled.png

Jim Dettman (EE MVE)

A reboot is the simplest.

If this is a server, I can explain some other methods.

Jim.

SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

bfuchs

ASKER

Yes Jim,
this is on the server, would appreciate to get some other methods.
Thanks,
Ben

bfuchs

ASKER

Where do I have to install that, on my pc or on the server?

If that must be on the server then I guess will have to wait for another time, as I would need to get approval first. (besides that may also require a restart after installation..)

Thanks,
Ben

SOLUTION

Jim Dettman (EE MVE)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

bfuchs

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial