DoCmd.TransferDatabase acExport with several queries (1 Viewer)

[radek225]

I have a several queries to export in another accdb file. code below works great, BUT in every query MS Access shows pop up message about security with macros. It's annoying when I'm using RunTime. I know how to disabled it through regedit. But i need to send this file to my friedns and them will be working with my aplication. So is there any other possibilities to export data from accdb to another accdb without all the time clicking in security pop up?

   DoCmd.TransferDatabase acExport, "Microsoft Access", _
    sciezkaK, acTable, "QRGenKlient", "tblGenKlient"


   DoCmd.TransferDatabase acExport, "Microsoft Access", _
    sciezkaK, acTable, "QRGenzo", "tblGenrt"

ect.

 

[Grumm]

I lowered all the options of access on all the computers who possibly use the file. Also make sure the file is stored on a trusted location. That way it will allow most of the macro's.
Or you can sign your macro's : http://www.howto-outlook.com/howto/selfcert.htm
Pretty useful if the users are somewhere else on the world (or in space maybe)