Databases Reference
In-Depth Information
Databases
Databases
3.0/3.5
Collection of open Database objects
Groups
Groups
C
ollection of Group objects in a Workspace object
Users
Users
3.0/3.5
Collection of User objects for a Workspace object
A.19.2 Methods
Method
Parameters
Returns
Version
Description
BeginTrans
Sub
3.0/3.5
B
egins a new transaction
Close
Sub
3.0/3.5
Close the Workspace object
Ends the transaction and saves
any changes
CommitTrans
Sub
3.0/3.5
Name As String, Connect As
String, [Option]
Database 3.0/3.5
Creates a new Microsoft Jet
database (
.mdb
)
CreateDatabase
CreateGroup
[
Name], [PID]
Group
3.0/3.5
C
reates a new Group object
CreateUser
[Name], [PID], [Password]
User
3.0/3.5
Creates a new User object
OpenConnection
Name As String, [Options],
[ReadOnly], [Connect]
Opens a connection to a
database
Connection 3.5
Name As String, [Exclusive],
[ReadOnly], [Connect]
OpenDatabase
Database
3.0/3.5
Opens a database
Undoes any changes since the
l
ast BeginTrans
Rollback
Sub
3.0/3.5
A.19.3 Properties
Property Type Version Description
DefaultCursorDriver
L
ong
3
.5
S
elects the ODBC cursor library
IsolateODBCTrans Integer 3.0/3.5 Indicates whether multiple transactions are isolated (ODBC only)
LoginTimeout
L
ong
3.5
N
umber of seconds allowed for logging in to an ODBC database
Name
S
tring 3.0/3.5
N
ame of this Workspace object
UserName
S
tring 3.0/3.5
U
ser that created the Workspace object