"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: modSnippetADOJetADOX
Example code that shows how to work with Jet/Access data using the ActiveX Data Objects Security and DLL extensions (ADOX) object model
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modSnippetADOJetADOX module
|
|
ShowADOCreateableRecordset
|
Procedure
|
Shows how to create a file-based recordset without a connection to an actual database
|
|
ShowADOCreateJetTableWith
|
Procedure
|
Shows how to use ADO to create a new table in a Jet database.
|
|
ShowADOListConnectionProperties
|
Procedure
|
Shows how to list the properties of an ADODB connection
|
|
ShowADOOpenJet40SecuredDatabase
|
Procedure
|
Shows how to open a connection to a Jet version 4 database using ADO with parameters to control security, passwords, etc.
|
|
ShowADOOpenJet4DatabaseSimple
|
Procedure
|
Shows how to open a connection to a Jet version 4 database using ADO with simple parameters
|
|
ShowADOOpenJetDatabaseReadOnly
|
Procedure
|
Shows how to open a Jet database in read-only mode
|
|
ShowADOSetJetOption
|
Procedure
|
Shows how to set engine-level settings for Jet using ADO
|
|
ShowADOXCreateJetTable
|
Procedure
|
Shows how to create a new table in a Jet database using the ADOX library.
|
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)
