MVP Centre

Welcome to the MVP Centre. This page is the portal to a wealth of information about Microsoft Access.

ADO-specific code

You are free to copy and use any of the samples supplied on this website for use in your own projects, provided that all copyright notices remain intact as part of the code. You may not publish the code to any website or other medium without the express written permission of the copyright holder. Each sample is provided on an "as is" basis. No warranty is expressed or implied, and no support is offered.

ADO connections	How to open an ADO Connection using CurrentProject.Connection, and a datalink file.
ADO Command objects	How to use the ADO Command object.
ADO Parameters	How to use ADO Command parameters.
ADO Recordset basics	The basics of using ADO recordsets.
Creating disconnected recordsets	How to create & use disconnected ADO recordsets.
Using persistent ADO recordsets	How to persist an ADO recordset to a file (XML & ADTG).
Creating schema recordsets	How to create & use ADO schema recordsets.
Creating shaped recordsets	How to create & use ADO shaped recordsets.
Recordsets containing multiple SELECT statements	Ever wondered why Access queries have ";" at the end. Find out.
Recordcount	Using the ADO RecordCount property.
Find	Using the ADO Find method.
Seek	Using the ADO Seek method.
Adding rows to a recordset	Adding rows to an ADO recordset.
Cancelling recordset edit operations	How to cancel Edit mode.
Recordset clones	Creating & using ADO recordset clones.
Deleting rows	How to delete rows from an ADO recordset.
Testing for empty recordsets	Discover how to test for an empty recordset.
Using arrays with recordsets	How to add & retrieve data using arrays.
Using Bookmarks	All about using Bookmarks.
MoveNext & MovePrevious	Navigating the ADO recordset, using MoveNext, MovePrevious, MoveFirst, MoveLast, AbsolutePosition & AbsolutePercent.
ADO Transactions	Managing transactions in ADO.