IBM Support

Repair Microsoft Access database files (like tds.mdb) on the machine which don't have Microsoft Access Software installed.

Troubleshooting


Problem

Using the Microsoft ® Access ODBC driver, you can repair or compact a Microsoft Access database. This functionality is accessible from the ODBC Control Panel, through the ODBC Microsoft Access Setup dialog box.

Resolving The Problem

Using the Microsoft Access ODBC driver, you can repair or compact a Microsoft Access database. This functionality is accessible from the ODBC Control Panel, through the ODBC Microsoft Access Setup dialog box. This repair and compact functionality works correctly for non-password protected databases.

In Windows open Control Panel locate the ODBC and double click on it. In USER DSN, click ADD, locate and choose Microsoft Access Driver(.mdb), and click 'Finish' which will Open 'ODBC Microsoft Access Setup'. Enter in any name and click ‘Select’ in the ODBC Microsoft Access Setup dialog box to open an existing database via the Select Database dialog box.

Click on ‘Repair’, and then in the Repair Database dialog box, select the file and path. Click OK.

The rational testing project database files are located on the following directories:

projectpath\testdatastore\tds.mdb


projectpath\testusersandgroups\tds.mdb
projectpath\testdatastore\defaultestscriptdatastore\tds.mdb



[{"Product":{"code":"SSSHVH","label":"Rational TestManager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Datastore","Platform":[{"code":"PF033","label":"Windows"}],"Version":"2002.05.00;2002 Release 2;2002.05.20;2003;2003.06.00;2003.06.12;2003.06.13;2003.06.14;2003.06.10","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

More support for:
Rational TestManager

Software version:
2002.05.00, 2002 Release 2, 2002.05.20, 2003, 2003.06.00, 2003.06.12, 2003.06.13, 2003.06.14, 2003.06.10

Operating system(s):
Windows

Document number:
338853

Modified date:
16 June 2018

UID

swg21202044