A friend recommended that I join this forum to answer some questions rather than him.....
I have a very large Access database hosted in the States (It's expensive here in NZ) and every so often the database locks up. When I open the database folder there are two files, db.mdb and db.ldb. The ldb file is obviously the lock file.
The asp pages related to the database cannot access the database because of the lock file. I cannot delete the ldb file and have to get the webmaster to delete this file for me. He recommended that I use a script to "throw up an ODBC error" to unlock it. He also said that Cold Fusion has a utility that can do this so there should be something with ASP.
Does anyone know what he's talking about and could someone point me in the right direction?