Beginning Access 1002002 Vba [Electronic resources]

Robert Smith; Dave Sussman Et al

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

Workspace

Methods

Name

Returns

Description

BeginTrans

Begins a new transaction.

Close

Closes an open

DAO object.

CommitTrans

Ends the transaction and saves the changes.

CreateDatabase

Database

Creates a new Microsoft Jet database (

.mdb).

CreateGroup

Group

Creates a new

Group object.

CreateUser

User

Creates a new

User object.

OpenConnection

Connection

Opens a connection to a database

OpenDatabase

Database

Opens a specified database.

Rollback

Rolls back any changes since the last

BeginTrans .

Properties

Name

Returns

Description

Connections

Connections

Collection of

Connection object.

Databases

Databases

Collection of open

Database object. Read-only.

DefaultCursorDriver

Long

Selects the

ODBC cursor library

Groups

Groups

Collection of

Group objects in a

Workspace or

User object. Read-only.

IsolateODBCTrans

Integer

Sets or returns a value indicating whether multiple transactions are isolated.

LoginTimeout

Long

Number of seconds allowed for logging in to an

ODBC database

Name

String

Returns the name of this object.

Properties

Properties

Collection of

Property object. Read- only.

Type

Long

Type (

Field ,

Parameter ,

Property .) Read-only.

UserName

String

Sets or returns a user or group.

Users

Users

Collection of

User objects for a

Workspace or

Group object. Read-only.