Welcome back! Ask questions, get answers, and join our large community of tax professionals.
Showing results for 
Search instead for 
Did you mean: 

Locating the DMS Database

Intuit Help

Locating the DMS Database

I need to locate the Document Management System (DMS) database but I'm not sure where it is located.


If you have DMS installed on a machine that is able to view the database, you can find the database path from within the program.

Follow these steps to locate the database path from within the program:

  1. Open Document Management System.
  2. In the bottom middle of the screen, find where it says Current Database Path: and note the path listed.
  3. If DMS does not open to a database, or it opens to the wrong one, follow the steps below.  Otherwise, continue to Step 4.
    1. The bottom of the Database menu should contain the last several databases accessed.  Start from the top and try accessing each database to determine which one is correct.
    2. Go to File.
    3. Select Database.
  4. Close DMS once the database path has been noted.

If you are unable to find the correct database path this way, you can try searching for DATA01A.dat, a file associated with all DMS databases.

  1. Click the Start orb.
  2. When the Start menu pops up, click in the Search bar at the bottom.  Type DATA01A.dat.  The Start menu should populate with results.
  3. Click See all results at the bottom of the Start menu.
  4. The Search Results window will display, showing all search results along with the directory in which they were found.  Each result will correspond with a DMS database.
  1. Press the Windows key and E on your keyboard.  This will open the File Explorer app.
  2. In the search box near the top right of the screen, type DATA01A.dat.
  3. File Explorer should populate with results along with the directory in which they were found.  Each result will correspond with a DMS database.

Before you begin: Back up your registry before continuing.  See, How to back up and restore the registry in Windows for instructions.

  1. Open your Registry by typing Regedit into the Windows Start Menu's Search field or a RUN line.
  2. Locate this Key:  HKEY_CURRENT_USERSoftwareLacerteDMSProgramOptionsLastDataLocation
  3. Open, and it will display the location of the last database opened.

Was this helpful?

You must sign in to vote, reply, or post