Acc 2007 shows a warning on all VBA code

[DougP]

Is there a way to shut this off. 90% of what I do is write VBA code to automate the database. There is a warning message and an optoins button, clicking it, allows a radio button to be checked and then it runs the VBA code. how do I have it run it all the time and not have the warning?

DougP

 

[pbaldy]

See if the Trusted Locations info in the Configuration area is what you're after:

http://allenbrowne.com/Access2007.html#Configuration

Paul
MS Access MVP 2007/2008

 

[Remou]

You may find self-certifying the code may suit:

http://office.microsoft.com/en-us/access/HP010397921033.aspx

 

[DougP]

OK I have this from pbaldy's suggestion.

"Add the path where your databases are stored: Office Button | Access Options | Trust Center | Trusted Locations."

When I click the Office button there is no Access options?
either with the database opened or closed.
I don't have service pack 1 installed.

DougP

 

[DougP]

Nevermind, I found it,its not a menu option its a button at the bottom of that menu in the border of the menu.

But now I get another message saying the F:\Task Order is not secure.
There is a check box on that screen saying allow network folders (not recommended)
So now I have it, but it's not as straight forward as the above...



DougP

 

[Remou]

There is even a course on digital signatures. Here is the end of it:

http://office.microsoft.com/trainin...ID=RP102380771033&CTT=6&Origin=RP102380761033

 

[DougP]

Ok here are the complete steps

Open Access 2007
click Office Button (round button in upper left)
(look at the bottom of that menu for 'Access Options' button, its located in the menu border.)
Click Trust Center on the left.
Click trust center settings (middle left button)
in the upper the left "Trusted locations"
At the bottom check "Allow trusted locations on my network.."
at the bottom "Add new location"
Browse to folder where database is located.
check the "subfolders of this location..."
Click OK all the way back out.
That should do it.



DougP