"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
|
|
Class: CAccessAutomation
Working with the Access Object Model through Automation
Most of the functionality available in Access can be called from an external program, such as one written in Visual Basic 6 or Excel.
This class contains methods and properties that show you how to get to database objects in an Access database.
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the CAccessAutomation class
|
|
AccessPath
|
Property
|
Path where Access is installed
|
|
AccessVersion
|
Property
|
Access Version number
|
|
AppAccess
|
Property
|
Handle to the Access application
|
|
Visible
|
Property
|
Returns the visible property of the current instance of Access
|
|
WorkgroupPath
|
Property
|
The workgroup information file contains security definitions of users, groups and permissions for Access and Jet databases.
|
|
Class_Terminate
|
Terminate
|
Clean up
|
|
CloseAccess
|
Method
|
Closes the instance of Access
|
|
CloseDatabase
|
Method
|
Closes the current open database
|
|
CloseObject
|
Method
|
Close an object
|
|
DeleteObject
|
Method
|
Deletes the named object from the database
|
|
DuplicateObject
|
Method
|
Duplicates (copies) the specified object to a new name (an object with the new name must not already exist)
|
|
ExecuteSQL
|
Method
|
Executes an action query represented by a SQL string
|
|
ExportObject
|
Method
|
Exports the named object from the current database to another database in the specified format.
|
|
ImportObject
|
Method
|
Imports the named object into the current database
|
|
OpenAccess
|
Method
|
Starts an instance of Access without opening a database; not needed if the OpenDatabase function is called
|
|
OpenDatabase
|
Method
|
Opens the specified database in the current instance of Access
|
|
OpenForm
|
Method
|
Opens the specified form
|
|
OpenQuery
|
Method
|
Opens the specified query
|
|
OpenReport
|
Method
|
Opens/prints the specified report
|
|
OpenTable
|
Method
|
Opens the specified table
|
|
ReportPrintPages
|
Method
|
Print a range of pages from a report
|
|
TableToXML
|
Method
|
Uses the ExportXML method to export data from a table to XML
|
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)
