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

Bill, If it were involving just me, I would do exactly that. However, I am training some nurses on what to expect using a couple of Access databases, and am trying to account for the situations that may arise when opening and using the database. Therefore, we have to account for the stinky Message Bar messages.

I've sent a frown on Access 2013. I can understand if there are Macros or other modifications, but just tables, queries, Forms and Reports - in otherwise a very simple database???? Not so much. Since they will get the prompt anyway, I guess I don't have to shy away from building automation into the database after all.

Thank You Gina and Bill for weighing in on this question.

Dawn

Answer 3

So any database has to be a trusted one? That's crazy!

 

Word, Excel and PowerPoint don't do that. They only request to become trusted when automation is added. Access should be the same. An Access database which is a relational spreadsheet should not require extra security checks.

 

Thanks

Dawn

Dawn

You can do what I do. Set the Macro security to allow all macros.

File tab>Options>Trust Center>Trust center Settings>Macro Settings>Enable all Macros.

Then you can forget about Trusted Locations. Just don't open databases from sources you don't trust.

Answer 4

Yes, any database has to be in a Trusted Location and it has been like that since Access 2007.  Also, true that it does apply to the other applications.  I will agree it's a but annoying but that is the way it is.

Answer 5

So any database has to be a trusted one? That's crazy!

Word, Excel and PowerPoint don't do that. They only request to become trusted when automation is added. Access should be the same. An Access database which is a relational spreadsheet should not require extra security checks.

Thanks

Dawn