Use the CreateQueryDef method to create a persistent or temporary query definition. Use the CreateProperty method to define new Database properties. Use the CreateTableDef and CreateRelation methods to create tables and relations, respectively. With a Microsoft Access database engine database, you can also use other methods, properties, and collections to manipulate a Database object, as well as create, modify, or get information about its tables, queries, and relationships. Use the Version property to determine which version of a database engine created the database. Use the OpenRecordset method to execute a select query and create a Recordset object. Use the RecordsAffected property to determine how many records were changed by an action query. Set the QueryTimeout property to limit the length of time to wait for a query to execute against an ODBC data source. Set the Connect property to establish a connection to an ODBC data source. Use the Execute method to run an action query. You use the Database object and its methods and properties to manipulate an open database. A Database object represents an open database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |