December 26th, 2003, 11:19 AM
|
|
Junior Member
|
|
Join Date: Dec 2003
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Transferdatabase
I have an Access Database where I need to export a table to another Access Database. The source database is secured and the destination database is locked by a single password. I have tried both using a Macro and VB code and I get the same result. No errors come up but the table is not transfered. Any ideas? Am I missing something? Below is the VB Code I have.
DoCmd.TransferDatabase acExport, "Microsoft Access", _
"T:\Operations\Funding Reports\Report Wizard\Summary Feed.mdb", acTable, "Direct Summary with Aging", _
"Direct Summary"
If you know anything about this method and require more info please let me know.
Thanks a lot.
Last edited by jediracer : December 29th, 2003 at 08:22 AM.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
