Dedicated Hosting Forums

Hello all,
How do I unlock an Access Database?

Is it an MDB file or an MDE file?

If it is MDB file then overwrite an active database with a new .MDB file.

There are way to unlock your database:

1.Run a Bad Query
Some database locks are broken by a bad query. For example, the following code snippet may unlock your database file:

<cfquery name="UnlockDB"
datasource="MyDSN">
SELECT *
FROM NoSuchTable
</cfquery>