Compact And Repair A TATEMS Database

Compact And Repair A TATEMS Database


If your data file is on the same computer where TATEMS is installed then close TATEMS.


Then make a backup copy of your database file just for an extra level of safety. 


The database file is called tatems2005be.mdb  and should be located inside the TATEMS 2005 folder which is inside either C:\Program Files or C:\Program Files (x86) 


Then search the word "Compact" in Windows start menu. 


You should see a Compact & Repair TATEMS Data File (This Computer) 


Click on that shortcut in the search or start menu and the Compact and Repair Processes will start. 


Wait for the screen to close.  This may take a number of minutes depending on how big your database and how fast your computer is. 


I have seen it take as long as 25 minutes on some machines and a split second on others with small databases.

For Network Environments 


To do a compact and repair on the data file if the data file is on a network you will need to copy the data file to a local machine that has a current installation of TATEMS.

Copy it to the \TATEMS 2005\ folder that is inside either:

C:\Program Files\
or
C:\Program Files (x86)\

but you should rename the empty data file (tatems2005be.mdb) in that folder first to tatems2005be-old.mdb then paste the file from the network into that folder.

Be sure TATEMS is closed then in the Windows Start menu there a shortcut called "Compact & Repair TATEMS Data File (This Computer)"

Click that and wait for it to finish.

Then go cut the file that has been repaired and before you paste it back in to the shared location on the network you should rename the original one in that folder to something like:

tatems2005be-backup-date.mdb

  1. Paste the file that you did the compact and repair on into the appropriate folder on the network. 
  2. Go back to the local TATEMS 2005 folder and rename the empty data file back to its original name "tatems2005be.mdb" (without the quotes).
  3. Then try TATEMS again.

If you need to restore the data file from a backup see the page here:
    • Related Articles

    • Database is in an Unrecognized Format or Inconsistent State

      There was a Windows update in May 2018 that started causing Microsoft Access databases that are stored on different computer to become corrupted numerous times a day. See this article here for full details and work arounds. ...
    • TATEMS Data file corruption

      Data file corruption can be repaired automatically starting with TATEMS version 4.6.28.000 and improved even further in 4.6.28.001 If you are eligible you can get the current update here: https://tatems.com/updates If you have expired you can renew ...
    • TATEMS Error Number 52 Error Description: Bad file name or number cause by server being down

      If you get this message Error Number: 52 Error Description: Bad file name or number Doc Name: fdlgBackupAndCompact Procedure Name: Form_Load It is typically because you have lost connection to your company server that is hosting the TATEMS back-end ...
    • Can't update TATEMS version or can't find current database file

      !!Warning!! Always make a backup copy or rename any database file (tatems2005be.mdb) before you overwrite it!  The Virtual Store in Windows Vista and in Windows 7 can cause updating issues and database location issues with TATEMS.  You should turn ...
    • TATEMS Backup

      To Backup TATEMS Data: Here is a video we created to show you how to backup: See the above video on Youtube https://youtu.be/JLT2tePuz0o In order to save and backup your TATEMS data, you need to make a backup copy of a file called tatems2005be.mdb. ...