| |
Users Object
A Users collection contains all stored User objects of a Workspace or Group object. The Users object has one property, Count, which returns the number of objects in a collection.
Users Object Method
| Method |
Description |
| Append() |
Adds a new DAO object to a collection. |
| Delete() |
Deletes a persistent object from a collection. |
| Refresh() |
Updates the objects in a collection to reflect the current database's schema. |
User Object
A User object represents a user account that has access permissions when a Workspace object operates as a secure workgroup.
Use Object Properties
| Property |
Description |
| Name |
Sets or returns a user-defined name for a DAO object. For an object not appended to a collection, this property is read/write. |
| Password |
Sets the password for a user account. |
| PID |
Sets the Personal Identification (PID) for either a group or a user account. |
User Object Method
| Method |
Description |
| CreateGroup() |
Create a new group. |
| NewPassword |
Changes the password of an existing user account or Microsoft Jet Database. |
Workspaces Object
A Workspaces contains all active, unhidden Workspace, objects of the DBEngine object. The Workspaces object has one property, Count, which returns the number of objects in a collection.
Workspaces Object Methods
| Method |
Description |
| Append() |
Adds a new DAO object in a collection. |
| Delete() |
Deletes a persistent object from a collection. |
| Refresh() |
Updates the objects in a collection to reflect the current database's schema. |
Workspace Object
A Workspace object defines a named session for a user. It contains open databases, and provides mechanism for simultaneous transactions, and, in Microsoft Jet workspaces, for secure workgroup support. A Workspace object also controls whether you are going through the Microsoft Jet Database Engine or ODBCDirect to access external data.
Workspace Object Properties
| Property |
Description |
| IsolateODBCTrans |
Sets or returns a value that indicates whether multiple transactions that involve the same Microsoft Jet-connected ODBC data source are isolated. |
| Name |
Sets or returns a user-defined name for a DAO object. For an object not appended to a collection, this property is read/write. |
| LoginTimeout |
Sets or returns the number of seconds before an error occurs when you attempt to log on to an ODBC database. |
| Type |
Sets or returns a value that represents a user, a group of users, or the owner of a Workspace object. |
| UserName |
Sets or returns a value that represents a user, a group of users, or the owner of the Workspace object. |
| DefaultCursorDriver |
Sets or returns the type of cursor driver used on the connection created by the OpenConnectio() or OpenDatabase() methods. |
Workspace Object Methods
| Method |
Description |
| BeginTrans() |
Begins a new transaction. |
| CommitTrans() |
Ends the current transaction and saves the changes. |
| Rollback() |
Rollback() ends the current transaction and restore the databases in the Workspace object to the state they were in when the current transaction began. |
| Close() |
Closes an open DAO object. |
| CreateGroup() |
Creates a new database group. |
| CreateDatabase() |
Creates a new Database object, saves the database to disk, and returns an opened Database object. |
| CreateUser() |
Creates a new User object. |
| OpenDatabase() |
Opens a specified database in a Workspace object and returns a reference to the Database object that represents it. |
| OpenConnection() |
Opens a Connection object on an ODBC data source. |
Copyright� 2000 by Noel
|