security alert on all Access databases

Question

Whenever I open an Access 2007 file, even a brand new one, there a security alert at the top: "Security Warning  Certain content in the database has been disabled". If I click on the Options button it says "VBA Macro   Access has disabled potentially harmful content in this database...."

I can't figure out what this is referring to. I didn't create any VBA macros, it occurs with a new Access file, if I type alt-F11 it only shows the one open file with nothing in it...

What is this warning about?

Thanks!

Answer 1

Access will notify you of that regardless of whether you have VBA in it or even if you haven't used any of the macro actions considered potentially unsafe.  What you need to do is to set the database's location as a trusted location and then you won't get that anymore.

See here for how to do that:

http://www.btabdevelopment.com/ts/default.aspx?PageId=13

Answer 2

If I have a volume mounted as a drive letter, how do I find its UNC? Does it even have one if it's not being shared?

Thanks!

Answer 3

Instead of Browing to them you could use a UNC (Universal Naming Convention) path like

\\ServerNameHere\ShareNameHere\FolderName\

Answer 4

Seems silly to generically put up a warning when there is no dangerous content. I don't understand the logic at all...

In any case, thanks for the info. There is a complication, though, which is that many of my databases reside on Truecrypt encrypted volumes which may not necessarily always be mounted to the same place, and therefore I'm not sure how I would create a trusted location for them. I guess I'll just have to live with manually closing the error each time.

Answer 5

In addition to what Bob said, the following article gives an overview on this new Access / Office 2007 security model.

Get started with Access 2007 security - http://office.microsoft.com/en-us/access-help/get-started-with-access-2007-security-HA010198047.aspx

Best Regards,

Nathan Ost

Microsoft Online Community Support