Errormessage: The security settings restrict access to the file because it does not contain a digital signature.

Question

Hello

I am trying to migrate from Access 2007 to the actual version. This does not work, I already asked this question with the error message but did not get any further.
What other possibilities do I have to solve this problem beside this community?

Thank you

Dana

Answer 1

It sounds, then, like the problem is in the accde which you created from the accdb, which you created originally.

So, the problem might be that you made some change to the accdb AFTER digitally signing it and BEFORE creating the accde from it.

Referring to the site linked above, you'll find this note:

Notes   

• If you want to prevent users of your solution from accidentally modifying your VBA project and invalidating your signature, lock the VBA project before signing it. However, locking your VBA project doesn't prevent another user from replacing the digital signature with another signature. Corporate administrators might re-sign templates and add-ins so that they can control exactly what users may run on their computers.
• If your application modifies the database in a way that will invalidate the signature, for example, by creating a new action query, then avoid digitally signing the database. Instead, use a signed package (.accdc) for distribution, and then combine that with the use of a trusted location.

Answer 2

Yes, I created the accdb.
Yes, the folder is a Trusted Location.

I already investigated for digital signatures. It is only possible to sign an accdb file. After extracting it on another computer, it does not open.

The unsigned accde returns the upward error message.

Signature is with global sign.

No, there is no restriction set by our IT.

Answer 3

Is this in an accdb you created yourself?

Do you have the folder where you placed the accdb designated as a Trusted Location?

You may want to investigate what Digital Signatures are and how they are applied. https://support.microsoft.com/en-us/office/show-trust-by-adding-a-digital-signature-5f4ebff3-360d-4b61-b2f8-ce0dfb53adf6

Have you consulted your organization's IT policy on using accdb/accde files? Is this a restriction imposed by your IT?