Home  |  About  |   Search   

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

RunCommand Constants

Terms of Use


 

Modules: Using DAO code in ADPs

Author(s)
Michael Kaplan

The new Access Data Projects in Access 2000 only support ADO. This means that if you are considering a move to ADPs from an Access 97 (DAO) environment, you will have to rewrite all your code (as commonly used functions like CurrentDB are no longer available in ADO). 

The code module ADO_to_DAO allows you to take an ADO Connection object to either a Jet or a SQL Server database (such as one from Access 2000's CurrentProject.Connection) and convert it into a DAO Database object. You can safely move to an .ADP and then worry about the move to ADO at a later date!

ADO_TO_DAO.bas

1998-2009, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer