Giorgio
Good catch! I didn't see that comma.
Regards,
Bill
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of giorgio_rovelli
Sent: Wednesday, November 21, 2012 5:44 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: DoCmd.CopyObject Question
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
<mailto:MS_Access_Professionals%40yahoogroups.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 <file:///\\dotnas2\homefolders> ...
doesn't follow Access
object-naming rules.".
>
> DoCmd.CopyObject , "\\dotnas2\homefolders\Transit\gm\SDO\olsent\Access
<file:///\\dotnas2\homefolders\Transit\gm\SDO\olsent\Access%0b2007%20Analysis%0b
Tools\ProductionTableBackups\ProductionTableBackups.accdb>
2007 Analysis
Tools\ProductionTableBackups\ProductionTableBackups.accdb", acTable,
"tblBiWeeklyStaticData"
>
> Do I need to open the destination DB before executing this statement?
> Thanks
>
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar