[AccessD] Naturally....

Hah! As usual, after several days of struggling with this, I figure out
the solution about 2.4 minutes after I emailed the list.  Thanks for the
inspiration - that is what I say :)

The magic syntax is
DoCmd.TransferDatabase acLink, "Microsoft Access", pcstrDataSource,
acTable, rsSP("sqlName"), rsSP("tblName"), False, True

Where "pcstrDataSource" is the path and file name.

Cheers
Darry.

Darryl Collins | IT PMO Integration Specialist
Cash Management Platform (CMP) Program

ANZ, Level 23, 55 Collins Street, Melbourne
Ph: +61 3 9652 1510 (Local: 03 9652 1510)
Mobile: +61 418 381 548 (Local: 0418 381 548)
Email: darryl.collins at anz.com <mailto:collinsd at anz.com> 




"This e-mail and any attachments to it (the "Communication") is, unless otherwise stated, confidential,  may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Australia and New Zealand Banking Group Limited ABN 11 005 357 522, or any of its related entities including ANZ National Bank Limited (together "ANZ"). ANZ does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication."