Returns a value that indicates whether you can change a DAO object. Returns a value that indicates whether an object supports transactions. Returns a TableDefs collection that contains all of the TableDef objects stored in the specified database. Returns a 16-byte value that uniquely identifies a database replica (Microsoft Access workspaces only). Returns a Relations collection that contains all of the stored Relation objects for the specified database. Returns a Recordsets collection that contains all of the open recordsets in the for the specified database. Returns the number of records affected by the most recently invoked Execute method. 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. No need to hire programmers or database developers every time you want a new database, and no need to hire a DBA to look after the database system. It’s part of the Microsoft Office suite, included in the Professional and higher editions or sold separately. Returns a QueryDefs collection that contains all of the QueryDef objects of the specified database. Microsoft Access is a relational database management system developed by Microsoft. Returns the Properties collection of the specified object.
Returns the name of the specified object. Sets or returns a 16-byte value that uniquely identifies the Design Master in a replica set (Microsoft Access workspaces only). Returns a Containers collection that represents all of the Container objects in the specifed database. Returns the Connection object that corresponds to the database (ODBCDirect workspaces only). Use ADO if you want to access external data sources without using the Microsoft Access database engine. NOTE: ODBCDirect workspaces are not supported in Microsoft Access 2013. Sets or returns a value that provides information about the source an open database. Returns a value that specifies the sequence of the sort order in text for string comparison or sorting (Microsoft Access workspaces only). (Microsoft Access database engine databases only.).
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.
Makes a new replica from another database replica (Microsoft Access workspaces only).Ĭhanges the password of an existing Microsoft Access database engine database (Microsoft Access workspaces only).Ĭreates a new Recordset object and appends it to the Recordsets collection. Runs an action query or executes an SQL statement on the specified object. MethodsĬreates a new user-defined Property object (Microsoft Access workspaces only).Ĭreates a new Relation object (Microsoft Access workspaces only).Ĭreates a new TableDef object (Microsoft Access workspaces only).
A Database object represents an open database.