Forums/Tips & Tricks

Repairing the Acquire Database with 4D Tools

Andrew Webb
posted this on September 20, 2011 12:10

In the unlikely event that Acquire™ crashes while writing data to disk, it will be necessary to check the database with an application called 4D Tools.

 

4D_Tools.jpg


Please inform Ambrit Ltd that you have had the problem. We will be able to offer advice on recovery and also would be interested to find out why it crashed in the first place! 

 

Requirements:

Acquire v2.0.0 or greater

 

Download 4D Tools:

Download 4D Tools from the following link:

http://www.ambrit.com/downloads/4dtools/4dtools.zip

 

Repairing the Database:

To fix your database follow these steps:

Screen_Shot_2011-11-07_at_10.11.48.png

Run 4D Tools by double clicking on the 4D Tools.EXE file.

 

Screen_Shot_2011-11-07_at_10.18.30.png

When 4D Tools opens it will ask you to locate your application, by default 4D Tools is looking for a file name of type "Structure File (*.4db)".

Change this to "Compiled Database (*.4dc)" in the popup menu at the bottom of the window.

Screen_Shot_2011-11-07_at_10.16.48.png

Choose the 4D Compiled database (.4dc) file which should be located in C:\Acquire\Database folder.

Click the 'Open' button.

4D Tools will automatically check the database when it is opened.

If it does not find any problems you can quit 4D Tools and start Acquire and continue to use it as normal.

If 4D Tools reports that a problem has been detected' click the 'Repair' button.

Screen_Shot_2011-11-07_at_10.13.19.png

This will prompt you to create a new file for the recovered data called Acquire_2.4dd

Click the 'Save' button ensuring that you are saving the file into the C:\Acquire\Database folder.

4D Tools will then repair the database. This might take a while

When it has finished go to the C:\Acquire\Database folder.


Screen_Shot_2011-11-07_at_10.54.01.png

You should have two .4dd (4D Data File) files:

Acquire.4dd

Acquire_2.4dd

 

and two .4dr (Data resource file) files:

Acquire.4dr

Acquire_2.4dr.


Rename the Acquire.4dd file to Acquire ddmmyy.4dd, where ddmmyy is the date.

Rename Acquire.4dr to Acquire ddmmyy.4dr, where ddmmyy is the date

 

Screen_Shot_2011-11-07_at_10.59.12.png

Move Acquire ddmmyy.4dd and Acquire ddmmyy.4dr to a C:\Acquire\Database\Backups folder (you may need to create this folder first).


Screen_Shot_2011-11-07_at_11.00.27.png

Rename Acquire_2.4dd (4D Data File) to Acquire.4dd

Rename Acquire_2.4dr (Data resource file) to Acquire.4dr 


Screen_Shot_2011-11-07_at_10.43.28.png


Run Acquire.