Temp Tables in Access 2007, Transferdatabase warnings

[Dale Fye]

I've got a number of applications (FE/BE) which use temp tables to minimize
network traffic. Prior to moving to 2007, I would put these tables in a
temp.mdb file that I create when the application loads, and would then link
them to my FE.

With 2007, whenever I use the TransferDatabase method I get a "Microsoft
Office Access Security Notice" which indicates:

A potential security concern has been identified

Warning: It is not possible to determine that this content came from a
trustworthy source. You should ....

And then displays Open and Cancel options. Is there a way to disable this
popup when using TransferDatabase?

 

[Rick A.B.]

I've got a number of applications (FE/BE) which use temp tables to minimize
network traffic.  Prior to moving to 2007, I would put these tables in a
temp.mdb file that I create when the application loads, and would then link
them to my FE.

With 2007, whenever I  use the TransferDatabase method I get a "Microsoft
Office Access Security Notice" which indicates:

A potential security concern has been identified

Warning:  It is not possible to determine that this content came from a
trustworthy source.  You should ....

And then displays Open and Cancel options.  Is there a way to disable this
popup when using TransferDatabase?

Dale,

I'm no expert in this but could it be a trusted location issue? I
also use a lot of tmp databases but I use Tony's solution.

http://www.granite.ab.ca/access/temptables.htm

Hope that helps
Rick