File open(.ldb)

[CS]

I have an Access program which runs automatically each day using the windows
Scheduler. Offlate I notice after the process is done, the file does not
close itelf, rather I see the ldb for this file.There's no one in the file or
the program . I cannot delete the ldb file as it says that the "File is
shared" when there's no one in the porgram. We have to do a complete restart
of the server so that we could delete the ldb.

Could anyone suggest what this problem could be?

Thanks

 

[Van T. Dinh]

Sorry, I don't know what causes the LDB file to remain open but complete
re-start of server to delete an open LDB file is a bit of an overkill..

The network / server admin should be able to force-close the LDB file (after
ensuring that no one is using the database) and then delete it without
server re-boot. This can be done using the "Computer Management" console on
the server.

If you have Admin right and the Server is W2000 or later, you can use the
Administrative Remote Desktop to access the Server Desktop and run the
server's "Computer Management" console from your work-station.

 

[Dirk Goldgar]

Sorry, I don't know what causes the LDB file to remain open but
complete re-start of server to delete an open LDB file is a bit of an
overkill..

The network / server admin should be able to force-close the LDB file
(after ensuring that no one is using the database) and then delete it
without server re-boot. This can be done using the "Computer
Management" console on the server.

If you have Admin right and the Server is W2000 or later, you can use
the Administrative Remote Desktop to access the Server Desktop and
run the server's "Computer Management" console from your work-station.

It seems to me you ought to first make sure that Access isn't still
running on the server. Maybe the scheduled process doesn't successfully
close and exit Access. In addition to the possibility of a simple
oversight in the code, there could be bugs that prevent Access from
closing.