Share via

Code signing in accdb database

Anonymous
2019-08-05T20:45:29+00:00

What is "Access 2013 or later database" file format this article is referring to?

https://support.office.com/en-us/article/show-trust-by-adding-a-digital-signature-5f4ebff3-360d-4b61-b2f8-ce0dfb53adf6#bm2

Is it they just have misspelled Access 2003 with its old mdb file format? It looks like it is still not possible to sign code in accdb database created with Office 365 (Access 16.0.10730.20348) and I still have to use the old mdb file format if I want code signing to work; otherwise "Disable all macros except digitally signed macros" policy prevents the app from functioning normally. I've seen a lot of folks asking similar questions with no good answers. As others pointed out, the suggested "Package and Sign"  feature is utterly useless as it is creating a signed package with still unsigned accdb inside. Once unpacked from the archive, the database is still not trusted.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2019-08-08T10:03:39+00:00

After some discussion on a different platform, the information shown there is correct if you're using the older .mdb format. You just can't sign a .accdb or .accde file.

Was this answer helpful?

0 comments No comments

4 additional answers

Sort by: Most helpful
  1. Anonymous
    2019-08-12T21:44:16+00:00

    Some of those apps are over 15 years old. I don't do any new development in Access, but still have to support that pesky legacy code until it is replaced.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2019-08-12T17:38:45+00:00

    I agree with everything you said, which is why I would never deploy a commercial application in Access.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2019-08-12T16:15:17+00:00

    Yes, I can make a trusted location, but it is not the real solution to the problem. Trusted locations can be disabled by policies, and if not, nothing can prevent users from placing malicious apps in trusted locations.  I'll keep signed mdbs then.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2019-08-06T10:51:07+00:00

    I'm running 2019, and can perform the steps indicated here (and I've got a current Comodo/Sectigo certificate), but of course when I go to save it I get the message about not being able to sign an .accdb file. So the steps are correct, but of course they don't really work. Not sure why they're still there.

    In 2007 and above the only way to avoid that message is to place the database in a Trusted Location. You can create a Trusted Location with code, but if you're deploying this application you'd be much better off doing this in the installation process, otherwise, you'll always get that initial "This database is not trusted blah blah" message.

    Was this answer helpful?

    0 comments No comments