Help! Access DB File Locked!

Hi All

I am using OLEDB to connect to an Access DB and it does use the "admin" account as the default user to connect from within Access i.e. this is not a Windows account.

I have an ASP.NET web page that is trying to do a compact and repair using a jet/MDAC object called JRO (Jet Replication Object).

The problem is whenever I call the JRO object I get this error:

"You attempted to open a database that is already opened exclusively by user 'admin' on machine..."

If I try and delete the .ldb file it is ofcourse locked. I found that if I do a CTRL-ALT-DEL and end the aspnet_wp process I am then able to delete the .ldb file and then successfully execute the compact and repair from the ASP.NET web page.

The aspnet_wp process when ended simply restarts itself (a new instance no doubt) and in doing so cannot remember it had a lock on the access db.

My conclusion is that the aspnet_wp process locks the access db file for or on behalf of the "admin" user in the access db.

Even if all connections have been closed the aspnet_wp process has a lock on the database file!

I am still searching for a way to tell the aspnet_wp to let go of the access db file!

I did use getprocessbyname() from the ASP.NET page to try and kill the instance of aspnet_wp programmatically and try and force it to forget by starting a new instance of itself, but ofcourse IIS gets really upset and won't let me kill this process from an ASP.NET page because I figure that in this case its suicide and aspnet/IIS won't "kill" itself but would be happy to "kill" other processes.

Anyway, I would have been content with the "kill the aspnet_wp process instance" approach except it won't suicide.

Does anyone have any idea how I might tell the aspnet_wp process to let go of the acccess db file?

By the way, I found the only account you need in a dev environment is the ASPNET account with read/write access and also your own account if you want to browse the folder yourself. No other accounts needed.

Any ideas appreciated.

I think this one has me beaten

from howartthou
Windows XP Prof.
VS.NET 2003
IIS 5.1