DBEngine

team lib

Methods

Name

Returns

Description

BeginTrans

 

Starts a new transaction.

CommitTrans

 

Commits an existing transaction.

CompactDatabase

 

Compacts the database.

CreateDatabase

Database

Creates a new database.

CreateWorkspace

Workspace

Creates a new Workspace.

Idle

 

Frees Access, to allow the Jet Database Engine to complete any pending tasks .

ISAMStats

Long

Allows viewing of Jet statistics. Note: This method exists but is hidden

OpenConnection

Connection

Opens a new connection.

OpenDatabase

Database

Opens a new database.

RegisterDatabase

 

Adds the ODBC connection information to the registry

RepairDatabase

 

Repairs a database. Note: This method exists but is hidden.

Rollback

 

Rolls back a transaction.

SetOption

 

Allows temporary overwriting of the database engine.

Properties

Name

Returns

Description

DefaultPassword

String

Sets the password to use when a new Workspace is created.

DefaultType

Long

Indicates the type of workspace (i.e. Jet or ODBCDirect ) to use when a new one is created.

DefaultUser

String

Sets the user name to use when a new Workspace is created.

Errors

Errors

Collection of Error objects from the most recently failed DAO operation Read-only.

IniPath

String

Indicates the registry key containing information for the Jet database engine.

LoginTimeout

Integer

When logging in to an ODBC database, indicates the number of seconds to wait before an error is generated. The default value is 20.

Properties

Properties

Collection of Property objects. Read-only.

SystemDB

String

Indicates the path for the workgroup information file.

Version

String

Indicates the version of DAO in use. Read-only.

Workspaces

Workspaces

Collection of open Workspace objects. Read-only.

 
team lib


Beginning Access 2002 VBA
Beginning Access 2002 VBA (Programmer to Programmer)
ISBN: 0764544020
EAN: 2147483647
Year: 2003
Pages: 256

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net