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!
|