Hello all,
How do I unlock an Access Database?
Please help me
-
genesisadams936
- Posts: 5
- Joined: Thu Jan 22, 2015 4:19 pm
Re: Please help me
Is it an MDB file or an MDE file?
Re: Please help me
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>
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>