Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
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?