ACCESS FEED: RE: [MS_AccessPros] pros/cons to move a table from a databse to another copy object or transfer ?

Kamis, 02 Februari 2012

RE: [MS_AccessPros] pros/cons to move a table from a databse to another copy object or transfer ?

Terence-

CopyObject is export-only where TransferDatabase lets you export, import, or
link. Neither *moves* objects. So, CopyObject is limited to objects in the
current database whereas TransferDatabase lets you work with objects in either
direction.

Does that help?

John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Lahaina, HI)

-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Terence
Sent: Thursday, February 02, 2012 1:12 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] pros/cons to move a table from a databse to another
copy object or transfer ?

It seems that I could use either DoCmd.CopyObject or transfer database to move a
table from one databse to another. Does anyone have insight into the pros and
cons ?
terence

------------------------------------

Yahoo! Groups Links