| |
Containers Object
A Containers collection contains all the Container object that are defined in a database. The Containers object has one property Count, which returns the number of objects in a collection. The Containers object has one method, Refresh(), whose syntax is Refresh, with no parameters. This method updates the objects in a collection to reflect the current database's schema.
Container Object
A Container object groups similar types of Document objects together.
Container Object Properties
| Property |
Description |
| AllPermissions |
Returns all the permissions that apply to the current UserName property of the Container or the Document object, including permissions that are specific to the user, as well as the permissions that the user user inherits from membership in groups. |
| Inherit |
Sets or returns a value that indicates whether new Document objects will inherit a default Permissions property setting. |
| 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. |
| Permissions |
Sets or returns a value that establishes the permissions for the user or group identified by the UserName property of the Container or Document object. |
| Owner |
Sets or returns a value that specifies the owner of the object. |
| UserName |
Sets or returns a value that represents a user, a group of users, or the owner of a Workspace object. |
Databases Object
A Databases collection contains all Database objects opened or created in a Workspace object. The Databases object has one property, Count, which returns the number of objects in a collection. The Databases object has one method, Refresh(), whose syntax is Refresh, with no parameters. This method updates the objects in the collection to reflect the current databases schema.
Database Object
A Database object represents an open database.
Database Object Properties
| Property |
Description |
| CollatingOrder |
Returns a value that specifies the sequence of the sort order in text for string comparison or sorting. |
| Connect |
Sets or returns a value that provides information about the source of an open connection, an open database, a database used in a pass-through query, or a linked table. For Database objects, new Connection objects, linked tables, and TableDef objects not yet appended to a collection, this property setting is read/write. For QueryDef objects and base tables, read-only. |
| 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. |
| QueryTimeout |
Sets or returns a value that specifies the number of seconds to wait before a timeout error occurs when a query is executed on an ODBC data source. |
| RecordsAffected |
Returns the number of records affected by most recently invoked Execute() method. |
| Version |
Returns the version of DAO currently in use. |
| VixNullBehavior |
Indicates whether zero-length string ("") used in code to fill Text or Memo fields are converted to Null. |
| Updatable |
Returns a value that indicates whether you can change a DAO object. |
| Transactions |
Returns a value that indicates whether an object supports transactions. |
| Replicable |
Sets or returns a value that determines whether a database or an object in a database can be replicated. |
| ReplicaID |
Returns a 16-byte value that uniquely identifies a database replica. |
| Connection |
On a Database object, returns the Connection object that corresponds to the database. |
Database Object Method
| Method |
Description |
| Close() |
Closes an open DAO object. |
| CreateProperty() |
Creates a new user-defined Property object. |
| CreateQueryDef() |
Creates a new QueryDef object in a specified Database object. |
| CreateTableDef() |
Creates a new TableDef object. |
| Execute() |
Runs an action query or executes an SQL statement on a specified Database. |
| CreateRelation() |
Creates a new Relation object. |
| NewPassword() |
Changes the password of an existing user account for Microsoft Jet database. |
| MakeReplica() |
Makes a new replica from another database replica. |
| Synchronize() |
Synchronizes two replica. |
| OpenRecordset() |
Creates a new Recordset object and appends it to the Recordsets collection. |
| PopulatePartial() |
Synchronizes any changes in a partial replica with the full replica, clears all records in the partial replica, and then repopulates the partial replica based on the current replica filters. |
Copyright� 2000 by Noel
|