"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: modJetDatabase
Creating and setting primary Access database characteristics
|
Procedure Name
|
Type
|
Description
|
|
(Declarations)
|
Declarations
|
Declarations and private variables for the modJetDatabase module
|
|
ArchiveAccessObjects
|
Procedure
|
Creates archival copies of all objects from the source database into a new database.
This procedure uses the DAO CreateDatabase method to create a new empty database. It then uses the TransferDatabase action to copy the objects.
|
|
ArchiveJetTables
|
Procedure
|
Creates archival copies of all tables in the database into a new database.
This is similar to the ArchiveAccessObjects() function except that it only copies tables and their data.
|
|
CreateNewDatabase
|
Procedure
|
Create a new database with options to specify the database format, adding a password and whether it should be encrypted.
If the Access MDB is opened with a system workgroup, the new database automatically inherits those security settings.
|
|
Database_AllowBypassKey
|
Procedure
|
Set the database's AllowBypassKey property. If it's set to False, users can't hold the shift key down when the database loads to prevent the startup routines from running.
|
|
DatabaseCompactBasic
|
Procedure
|
Compact a standard database that is not under workgroup security to itself
|
|
DatabaseCompactGeneral
|
Procedure
|
Compact the specified database.
Note that Access cannot compact the current database from VBA code.
Set the database's Compact on Close option to do that.
|
|
DatabaseCompactNew
|
Procedure
|
Compact a standard database that is not under workgroup security to a new database name
|
|
DatabaseDecrypt
|
Procedure
|
Decrypts the named database or a copy of the database
|
|
DatabaseEncrypt
|
Procedure
|
Encrypts the named database to itself or to a new database
|
|
DatabasePasswordChange
|
Procedure
|
Change the password of a database or create a copy of the database with the new password
|
|
DatabasePasswordRemove
|
Procedure
|
Remove the password for a database or create a copy of the database without a database password
|
|
DatabasePropertyCreate
|
Procedure
|
Create a new Jet/DAO database property
|
|
DatabasePropertyExists
|
Procedure
|
Does this Jet/DAO database property exist?
|
|
DatabasePropertyGet
|
Procedure
|
Get the value of a Jet/DAO database property
|
|
DatabasePropertySet
|
Procedure
|
Set a Jet/DAO database property value
|
|
FileOverwrite
|
Procedure
|
See if a file exists, and if so, optionally prompt the user to delete it, then deletes it.
|
|
RefreshContainers
|
Procedure
|
Refreshes all DAO containers in the specified database.
Because of the way DAO maintains its containers, you should generally refresh a container before relying on the accuracy of its contents. This function handles refreshing all DAO containers, and optionally (if the fAccessContainers parameter is set to True) the Forms, Reports, Scripts (Macros), and Modules containers.
|
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)
