Please help me

[zacharywhite768]

Hello all,
How do I unlock an Access Database?

[genesisadams936]

Is it an MDB file or an MDE file?

[clarke578]

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>

[josephethan67]

In Access, open the web app and use the Table Selector in the left pane to choose the table you wish to lock. Select Lock from the Settings/Actions menu. Next to the table's name, the Lock icon appears. To unlock a table, repeat the steps above and click Unlock.

[dj76748]

ACCDB is the default Access file extension. The extension of the locking files is LACCDB, and they have the same name and location as the main database file. MDB and LDB were the extensions available prior to the 2007 version.
The LACCDB file remains open until the database's final user closes it. This locking file does not always destroy itself and must be manually deleted. If you know the database's name but not where it's kept, you have two choices: search for all files with the LACCDB extension or contact your network administrators and provide them with the information they need.