Terry
The path seems to be right, syntaxically (is this a word?) speaking. Are you
doing this from within the target database?
But you could also use the DoCmd.TransferDatabase
Regards,
Bill Mosca,
Founder, MS_Access_Professionals
That'll do IT <http://thatlldoit.com/> http://thatlldoit.com
MS Access MVP
<https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E>
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My Nothing-to-do-with Access blog
<http://wrmosca.wordpress.com> http://wrmosca.wordpress.com
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terry Olsen
Sent: Tuesday, November 20, 2012 12:04 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] DoCmd.CopyObject Question
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 2007
Analysis Tools\ProductionTableBackups\ProductionTableBackups.accdb
<file:///\\dotnas2\homefolders\Transit\gm\SDO\olsent\Access%202007%20Analysis%20
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 (2) |
Tidak ada komentar:
Posting Komentar