Run External DB from Currentdb

[Guest]

How do I use the transferDatabase action to recognize objects (tables) in an
external Access database?

I can set the workspace, set a database variable = external db, Open the
external dB, loop thru objects in the external db, but the transfer Database
thinks it is still in the currentdb, not the external db.

Here is the setup:
strTempDatabase = "C:\Development\Projects\2. 1rst_New_Pull_New_files\" &
"History_First_" & myYear & "_" & myCount & "_" & "01.mdb"

Set wrkDefault = DBEngine.Workspaces(0)
strPath = "C:\Development\Projects\PSA_Import.mdb"
Set dbPSA = wrkDefault.OpenDatabase(strPath)

DoCmd.TransferDatabase acExport, "Microsoft Access", strTempDatabase,
acTable, "REO", "AllDeals_112904211851", 0

dbPSA.Close

Thanks

Ross

 

[Guest]

hi Ross,
I am not exactly sure what your are trying to do but i
have had some luck with working with external databases.
i used Gary Robertson's remote query article to get
started. he includes so sample code.
http://www.vb123.com/toolshed/02_accvb/remotequeries.htm
good luck.

 

[Guest]

Thank you, I'll check it on Monday

hi Ross,
I am not exactly sure what your are trying to do but i
have had some luck with working with external databases.
i used Gary Robertson's remote query article to get
started. he includes so sample code.
http://www.vb123.com/toolshed/02_accvb/remotequeries.htm
good luck.