Record is deleted

[Guest]

When running a query I have the error message 'Record is deleted' and the query stops. This is a 'Jet' error message and has a reference of 3167. Is there any way I can suppress the error and/or clean up the deleted records? Regards
Fred

 

[Guest]

I am from the Access support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue

Thank you

Enterprise Project Consulting

 

[Michel Walsh]

Hi,




Your post is not appropriate in this newsgoup.


Vanderghast, Access MVP

I am from the Access support department at

http://www.enterpriseprojectconsulting.com and we would be happy to assist
you in resolving your issue.

 

[Michel Walsh]

Hi,


If the error occur when you open the database, when no other VBA code is
running under the scene, it may be because the database is corrupted. Have
you tried to "compact and repair" (Tools | Database Utilities ... |
Compact and Repair )?


Hoping it may help,
Vanderghast, Access MVP

When running a query I have the error message 'Record is deleted' and the

query stops. This is a 'Jet' error message and has a reference of 3167. Is
there any way I can suppress the error and/or clean up the deleted records?
Regards,