If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to Register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.
The solution is incredibly simple, as will be this article. Unlock MDB does exactly what the name says – unlock protected MDB files of MS Access database. The program recovers MDB passwords for the MS Access documents the trick to unlocking the hold on the MDB file is to simply throw it a query that will cause an error. The easiest way to do that is to attempt a select from a table that doesn't exist.
Unlock MDB - Access Password Recovery program can do the following:
*Recover lost Access database passwords
*Copy the recovered password in a clipboard.
*Recover access password instantly.
*Recover multilingual passwords.
*Unlock & unprotect protected .mdb files of MS Access
The solution is incredibly simple, as will be this article. The trick to unlocking the hold on the MDB file is to simply throw it a query that will cause an error. The easiest way to do that is to attempt a select from a table that doesn't exist. Code like this should do the trick (unless you're really strange and actually have a table named "whereveryoucanfindthem" and a field named "cutemeerkats").
<cfquery name="unlockmdb" datasource="dbnamegoeshere">
Place this snippet into a file (I call mine die.cfm), and then run it whenever you need to unlock the database. It could even be extended to accept a datasource name via the query string and unlock any database on your machine, but I'll leave that to anyone who wants to try it as an experiment (my goal here is for simplicity).
As a ColdFusion newbie about a year ago, I can distinctly recall the frustration of dealing with Microsoft Access database files which had been "locked" by the ColdFusion Application Server accessing them. I can remember being unable to delete or overwrite older database files, and trying stupid workarounds like uploading newly named databases (and having to change the resulting ODBC System DSN).