ADO CopyRecord and MoveRecord Methods

Home | About me | EXCEL VB Programming (XL97-2003) | ACCESS Programming | EXCEL VB.Net Programming | EXCEL Spreadsheet Functions Material Management  |  Guestbook
 

ADO CopyRecord and MoveRecord Methods

CopyRecord

The CopyRecord method copies a file or directory to another location.

MoveRecord

The MoveRecord method moves a file or directory to another location.

Note: The ParentURL property will not be automatically updated. You must close the Record and then open it again with the new URL.

Syntax

CopyRecord(source,destination,username,password,optios,async)
MoveRecord(source,destination,username,password,options,async)
 

Example

objRecord.CopyRecord strSourceURL, strDestinationURL, , , adCopyOverWrite
' some code....
objRecord.Close
' some code....
objRecord.Open strDestinationURL

 

objRecord.MoveRecord strSourceURL, strDestinationURL, , , adCopyOverWrite
' some code....
objRecord.Close
' some code....
objRecord.Open strDestinationURL

Parameter

Description

source Optional. The URL of the file or directory that will be copied/moved
destination Optional. The URL to the location where source will be copied/moved
username Optional. The user ID that authorizes access to destination
password Optional. The password that verifies username
options For CopyRecord: Optional. A CopyRecordOptionsEnum value that specifies the behavior of this method. Default is adCopyUnspecified

For MoveRecord: Optional. A MoveRecordOptionsEnum value that specifies the behavior of this method. Default is adMoveUnspecified

async Optional. A Boolean value that, when True, sets this operation to be asynchronous

 

CopyRecordOptionsEnum Values

Constant Value

Description

adCopyUnspecified -1 Default. Will not allow over write or recursive copy
adCopyOverWrite 1 Overwrites the file/directory if it already exists
adCopyNonRecursive 2 Copies the current directory (none of its subdirectories) to the destination (this operation is not recursive)
adCopyAllowEmulation 4 Requests that the provider attempt to simulate the copy. If the attempt to copy the Record fails because the destination URL is on a different server or serviced by a different provider than the source, this may cause data loss

 

MoveRecordOptionsEnum Values

Constant Value

Description

adMoveUnspecified -1 Default. Will not overwrite any file/ directory at the destination location. Will also update links
adMoveOverWrite 1 Overwrites the file/directory if it already exists
adMoveDontUpdateLinks 2 Modifies the default behavior of MoveRecord method by not updating the links of the source Record. The default behavior depends on the capabilities of the provider
adMoveAllowEmulation 4 Requests that the provider attempt to simulate the move. If the attempt to move the Record fails because the destination URL is on a different server or serviced by a different provider than the source, this may cause data loss