You just need to click this icon to access the records saved in linked table. However, there are possibilities that when you click that icon, nothing happens. In most cases, this occurs due to corruption or damage of Access database. The best and easiest way to overcome such corruption scenarios is by restoring data from an updated backup. However, if no backup is available or backup fails to restore required data, then you will need to use advanced access repair application to repair your corrupted database.

As a practical scenario, when you attempt to open or delete a linked table (Employee table), no activity is performed. In addition, it does not show any error or warning message.

Cause:

The root cause for not opening or deleting the Employee table is corruption or damage of table. The table can be corrupted due to various factors like, file system corruption, application malfunctioning, software bugs, and more.

Resolution:

To resolve the above problem and access the records stored in Employee table, you will need to use an inbuilt repair utility named “Compact and Repair.” To use this utility to repair the table, you will need to follow the below steps:

1.

On the Tools menu, select Database Utilities and then click Compact and Repair Database.
2.

Search and click the database in the ‘Database to Compact From’ dialog box, and then click Compact.
3.

Select an correct folder location for the new file in the ‘Compact Database Into’ dialog box, type a unique name for the file and then click on Save.

However, if the above utility fails to resolve your issue and the data in Employee table still remains inaccessible, then you will need to use advanced Access Repair software. These access database repair application employ powerful scanning methods to repair data stored in MS Access tables. Built with highly graphical user-interface, these utilities are easy to implement and understand.

Stellar Phoenix Access Recovery is efficient Access Database Repair application that supports Microsoft Access 2007, 2003, XP (2002), and 2000. The non destructive software can restore and Repair Access database objects such as tables, queries, forms, reports, macros, and modules. The recovery utility is compatible with Windows Vista, XP, 2003, 2000 and NT operating systems.

http://www.repair-access-file.com/