I have several ASP pages that connect to an Access 97 database. I've found that if,
for whatever reason, my database crashes, the .ldb file will still show me as being logged on, even though I'm not. I've tried to delete the .ldb file, and I couldn't. I've gone into the server resources, and deleted all instances of someone using the database, and the .ldb still wouldn't let me delete it. The only thing I've found that works is rebooting the machine. But since this file is on a server that is being used by up to 100 people at one time, rebooting the server isn't always the best thing to do. To further complicate issues, if after the database crashed, and there remains an entry in the .ldb file, and someone tries to access one of the ASP pages, it causes a reaction that eventually shuts down all web serving for the entire server. This, as you can see, is extremely bad, and needs to be fixed.
At first glance, I think it'd be nice to have some way of being able to clear an .ldb file without rebooting (just deleting it is NOT an option, it doesn't work). Are there any programs out there that will let you clear the file? I've found some .ldb file programs types on Microsoft's web page, but I haven't found one that allows me to clear an .ldb file.
Any other possible suggestions on how to resolve this problem?
Thanks,
Dana
for whatever reason, my database crashes, the .ldb file will still show me as being logged on, even though I'm not. I've tried to delete the .ldb file, and I couldn't. I've gone into the server resources, and deleted all instances of someone using the database, and the .ldb still wouldn't let me delete it. The only thing I've found that works is rebooting the machine. But since this file is on a server that is being used by up to 100 people at one time, rebooting the server isn't always the best thing to do. To further complicate issues, if after the database crashed, and there remains an entry in the .ldb file, and someone tries to access one of the ASP pages, it causes a reaction that eventually shuts down all web serving for the entire server. This, as you can see, is extremely bad, and needs to be fixed.
At first glance, I think it'd be nice to have some way of being able to clear an .ldb file without rebooting (just deleting it is NOT an option, it doesn't work). Are there any programs out there that will let you clear the file? I've found some .ldb file programs types on Microsoft's web page, but I haven't found one that allows me to clear an .ldb file.
Any other possible suggestions on how to resolve this problem?
Thanks,
Dana