Security Warning on Empty Database

Question

I started a blank database .accdb type.

I have one table with three fields in it.

ID - AutoNumber

FName - Text

LName - Text

When I close and re-open the database I get a Message Bar indicating the database has MacroVBA in it. Are you kidding me?

Message Bar Settings says: "Show the Message Bar in all applications when active content, such as ActiveX controls and macros, has been blocked."

ActiveX Settings says: "Prompt me before enabling all controls with minimal restrictions" - and has a check mark in Safe Mode

If my database is just tables and queries, I don't understand why I am getting the message bar. Or is this a reported bug that I am just now finding about?

TIA

Dawn Bleuel

Answer 1

Put your database in a Trusted Location, see...

http://www.access-diva.com/d4.html

Side note...  The security warnings are for the entire database not just VBA and macros.

Answer 2

Daniel

Thanks so much for writing that script. It looks like something I can add to my original script for installing/updating my front ends.

Answer 3

I personally use a vbscript routine to launch my databases, part of this routine first ensure that a trusted location exists for the db by reading/writing to the appropriate registry keys.

The basic principle can be found: http://www.devhut.net/2010/06/23/vbscript-createset-trusted-location-using-vbscript/

Answer 4

Dawn

I guess it's to be expected. 2003 started us off with warnings if there were macros or code and the user could accept or reject their use. Gradually, MS tightened up security which I can understand. After all, VBA or even macros can be used to delete files, plant viruses, etc. One client I worked for just sent someone around to every computer and made the suggested settings I gave you.

Another way to go is to run a .reg file to create the trusted location in the user's registry. For Windows XP it would look like this:

[HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Access\Security\Trusted Locations\MyLocation]

AllowSubFolders (REG_DWORD) = 1

Path (REG_SZ) "C:\MyTrustedDatabaseFolderNo1"