As an Access developer — or even as a power user — you won't get far if you can't work with the Recordset object.But it's easy to go astray, and there are a number of mistakes that even experts make. Often, we're unaware of a subtle nuance between the two object libraries, Data Access Objects (DAO) and Active X Data Objects (ADO).Access workspace A workspace that uses the Access database engine to access a data source.The data source can be an Access database file, an ODBC database, such as a Paradox or Microsoft SQL Server database, or an ISAM database.action list The list that appears when you click the arrow in the Action column of the Macro object tab. Action queries include append, delete, make-table, and update queries. ADE file An Access project (file) with all modules compiled and all editable source code removed.Advanced Filter/Sort window A window in which you can create a filter from scratch.absolute or fixed positioning Places the element relative to either the element's parent or, if there isn't one, the body.Values for the element's Left and Top properties are relative to the upper-left corner of the element's parent.
If you are upgrading from Access 97, you will also need the information in article, Converting from Access 97. Unable to link Sybase database if File DSN contains spaces.(This hotfix is also in Office 2007 Cumulative Update for August 2010) If you are familiar with older versions, the new Access may leave you shocked and bewildered - unable to find a thing without the familiar menus, toolbars, and Database window. Once you recover, you unearth some seriously useful new functionality beneath that pretty face: Create a template database to be used any time you create a new database.
Because they are organized into functional topics and kept very short, none of the examples can stand alone. A minimum program would need to use a combination of the "Opening", "Displaying" and "Closing" topics.
You can cut and paste the short program topics into a working program.
The recordset interface is referred to as Active X Data Objects (ADO).
It requires a different syntax than DAO, but your experience with DAO will transfer nicely, and it has a much more powerful and consistent toolkit for accessing today's variety of PC and mainframe database formats on the Web.