Security Popup Warnings... How do I disable them?

[BadgerLikeSpeed]

Right... I'm creating a table in another access database (which was created earlier in the code), and I'm getting an Access Security Warning every time. When the code is executed it creates 7 new tables, and so the user gets 7 consecutive popups.
The text is (can't copy/paste):
A potential security concern has been identified.
Warning: It is not possible to determine that this content came from a trustworthy source. You should leave this content disabled unless the content provides critical functionality and you trust its source.
File Path: ....
This file might contain unsafe content that could harm your computer. Do you want to open this file or cancel the operation?
My code is

DoCmd.TransferDatabase acExport, "Microsoft Access", LFilename, acTable, "WatCrew", "WatCrew"

I've googled around, and tried bracketing the table creation section with DoCmd.SetWarnings False/True, but I'm still getting the warnings.
Any ideas? Is there any way that I can automatically acknowledge the warnings, since I've just created the database/tables from scratch I know that it is all ok...
And I can't edit the registries on the computers that this is to be run on, which removes another solution I've read.
All help is much appreciated!

 

[PeterF]

Is this in a runtime or with access 2010 and what version of Windows.
You don't get the warning straight from access (so setting warning on/off won't help), it is a windows protection mode to prevent unsigned code to run.
Placing your frontend in a trusted location should work.
For more info see: office.microsoft

 

[BadgerLikeSpeed]

Hi Peter,
It's running from a command button on a form in Access 2010, I'm running Windows 7 Enterprise. I take it I'd have to make a trusted location for the database on every computer that it runs on?

 

[AccessProgrammer]

Hi, just add the folder where you store the database into trusted sites. Also, make sure you tick mark on the option to add all the subfolders also.

In the same menu, you can also enable all macros to run without any pop ups. It may read that it is not safe. But just override it. All the best !!!

 

[BadgerLikeSpeed]

Cheers! I'm sure I'll be back with more questions soon enough...

 

[mdlueck]

And here you go with where those settings are stored in the registry...

Trusted Location / DB Security
http://www.access-programmers.co.uk/forums/showthread.php?t=217954

 

[AccessProgrammer]

Hope u cracked this ....