#Deleted Error in Microsoft Access Linked tables (1 Viewer)

Mohsin Malik

Registered User.
Local time
Today, 05:01
Joined
Mar 25, 2012
Messages
175
Hello,

I have developed a Microsoft Access 2010 database for my client and the database is split with Front-end/Back-end, the Back-end and the database is shared on Network, The client operating system and applications for all users are hosted and consistent and the service is delivered over Citrix.

The database some times corrupt the tables record and give a permanent #Delete Error, I have attached one of the database table and the screenshot of the error, Please see the candidate # 10, any idea that how to fix this issue?

Thank you
Mohsin
 

Attachments

  • Deleted Error.jpg
    Deleted Error.jpg
    94.9 KB · Views: 240
Last edited:

JHB

Have been here a while
Local time
Today, 02:01
Joined
Jun 17, 2012
Messages
7,732
To get rid of the "Deleted" record, do a "Compact and Repair" 2-3 times.
 

Mohsin Malik

Registered User.
Local time
Today, 05:01
Joined
Mar 25, 2012
Messages
175
To get rid of the "Deleted" record, do a "Compact and Repair" 2-3 times.

Hello JHB,

Thank you for the reply, I have done the compact and repair many times and its is not fixed, can you please review the database attached and do the compact/repair to see if it fixed and show the corrupted record Candidate # 10.

Thanks
Mohsin
 

JHB

Have been here a while
Local time
Today, 02:01
Joined
Jun 17, 2012
Messages
7,732
...can you please review the database attached and do the compact/repair to see if it fixed and show the corrupted record Candidate # 10.
Yes but as I wrote do a "Compact and Repair" 3 times after each other.
Database attached.
Edit:
Attached Database deleted.
 
Last edited:

Users who are viewing this thread

Top Bottom