You put a comma right after DoCmd.CopyObject which means you skip the
DestinationDatabase argument but in your case you need it.
Giorgio
--- In MS_Access_Professionals@yahoogroups.com, "Terry Olsen"
<terryomsn@...> wrote:
>
> 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 (3) |
Tidak ada komentar:
Posting Komentar