Beginning Access 1002002 Vba [Electronic resources]

Robert Smith; Dave Sussman Et al

نسخه متنی -صفحه : 256/ 202
نمايش فراداده

DBEngine

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.