Hi
In VBA, I'd like to copy an existing table from one database to another. I'm having trouble determining the URL naming convention to map to the destination DB.
The following statement raises the error message "Run-time error '2006' The object name \\dotnas2\homefolders... doesn't follow Access object-naming rules.".
DoCmd.CopyObject , "\\dotnas2\homefolders\Transit\gm\SDO\olsent\Access 2007 Analysis Tools\ProductionTableBackups\ProductionTableBackups.accdb", acTable, "tblBiWeeklyStaticData"
Do I need to open the destination DB before executing this statement?
Thanks
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar