Intuit HelpIntuit
How to resolve DMS database error 53249 when running a database repair
by Intuit• Updated 5 months ago
This article explains how to resolve the following error message that appears when attempting to repair the DMS database (DBRepair.exe):
"DMS Database Error: 53249, Invalid Database Path. Table Locks is missing from the specified path: 'C:\DMSdb\'"
- The path will be where the DMS database is stored.
Make sure all users are out of DMS before performing the following steps:
- Open DMS.
- Create a new database on the local hard drive (such as C:\Test) by selecting File menu > Database > New.
- Follow the Wizard to create the new database.
- In the Set Up Default Folder Template - Clients window, select Next.
- In the Choose Where to Import From window, select the option I don't want to import at this time and select Next.
- Close DMS.
- Browse to the new database folder (example is C:\Test).
- Hold down the CTRL key and select Locks.dat and Locks.idx.
- Right-click and select Copy.
- Browse to the original database folder.
- Inside the database folder, right-click and select Paste.
- Confirm to overwrite the existing files.
- Create a new folder inside this DMS database folder.
- Name this folder IDX files.
- Hold down the CTRL key and select all the .idx files (except Locks.idx) and the dbisam.lck file.
- Right-click and select Cut.
- In the IDX files folder, right-click and select Paste.
- Browse to C:\ProgramFiles\Intuit\DMS. (This is the default installation folder).
- Open the file DBRepair.exe and click OK to the Information prompt.
- Select the original DMS database folder inside the Database Maintenance window.
- Select Repair.
- When repair has finished, close the Database Maintenance window by selecting Exit.
- Open the DMS program.
- Select File > Database > Open.
- Select the original database and click OK.
- Make sure the database is present with no errors.