"The code is exactly
how I would like to write code and the algorithms used are very
efficient and well-documented."
Van T. Dinh, Microsoft MVP
|
|
|
Category:
|
Database : Access/Jet
|
|
Description:
|
Microsoft Access Jet databases and their objects (MDB and ACCDB database formats)
|
Module: modTableCopyDataADO
Copy records (excluding complex fields) using ADO
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modTableCopyDataADO module
|
|
CopyLargeFieldADO
|
Procedure
|
Copy contents of one large field to another due to max 32K chunk
|
|
CopyRecordADO
|
Procedure
|
Copy a record from one recordset to another based on field names.
The destination table/recordset must have all the fields of the source, but the order may be different and it may have additional fields.
Does not support complex (Attachment and MultiValue) field types, which require using DAO/ACE.
|
|
CopyRecordSimpleADO
|
Procedure
|
Copy a record from one recordset to another based on field names and no complex (multivalue or attachment fields) or large fields (>32K).
The destination table/recordset must have all the fields of the source, but the order may be different and it may have additional fields.
|
|
CopyTableDataADO
|
Procedure
|
Copy all the records from one table to another using ADO.
Does not support complex (Attachment and MultiValue) field types, which require using DAO/ACE.
The destination table must have all the fields of the source, but the order may be different and it may have additional fields.
|
Overview of Total Visual SourceBook
The source code in Total Visual
SourceBook includes modules and classes for Microsoft Access, Visual
Basic 6 (VB6), and Visual Basic for Applications (VBA) developers. Easily
add this professionally written, tested, and documented royalty-free code
into your applications to simplify your application development efforts.
Additional Resources
|
|
All Our Microsoft Access Products
(885K)
