Digital Signature Tampered Warning

[JPearson]

I have a database that populates the Digital Signature has been tampered with... warning everytime I open it after I have run the code. I have done some reserch and have discovered that this will occur if you have and action query that is modified by code.

Is there any work around for this?

Thanks
-JP

 

[Guus2005]

Not many people are using the Digital Signature. Me for one...

This is how i believe how it works.

De digital signature i based on a CRC or a Hash of the application. It changes when objects are changed in the application.

A simple solution of course is DON'T.

Instead of changing the query to meet your needs, Try to use parameter queries instead.
They have several more advantages above queries created on the fly. e.g. they are faster.

dim qdf as querydef
set qdf = currentdb.querydefs("qryParamDeletePerson")

qdf.parameter("PersonId") = lngID

qdf.execute

Share and Enjoy!