Unlocking of file on server

  • Thread starter Thread starter GeorgeMar
  • Start date Start date
G

GeorgeMar

I am not a LAN administrator and I am seeking some
instructions to direct the administrator. Is there a way
to release and delete the MS Access .LDB file, thus
releasing the .MDB without having to reboot?

I have an application in MS Access 2002 split in Front End
and Back End. The back end resides on a Win 2000 server.
Occasionally, the back end .MDB has locked up with
the .LDB file remaining open.

When the .LDB file is open nothing can be done to
the .MDB, e.g Copying it or Compacting it.

The only way I know of to release the LDB and MDB files is
to reboot. That is not always convenient for a server.

many thanks

george
 
You would need to determine what has the file locked, there is a sysinternals
tool that might help that will tell you what has a "handle" to an open file.

Note that this is only ONE of the reasons you shouldn't backend services to
Access. Access is a great little personal database, using it as a backend for
apps and web pages is a stretch, at the very least look at using MSDE.
 
Thank you Joe.

I have SQL Server 2000 Developer Edition for 5 users and
have not used it yet. A few questions if I may?
1. Is MSDE similar to the Access run-time version? Is
there any additional cost to me as the developer and to my
clients?

2. Does MSDE provide the full functionality of SQL? MS
Access run-time had some limitations placed on it so that
the users had to have the full version on their machines
for my applications to work?

3. What would my clients need to do if I migrate their
backend from MDB to MSDE?

4. Is there a site that lists the pros and cons of
migrating from Access to MSDE?

Thanks for your help
George
 
Back
Top