Updating sql server dao recordsets
DAO is the native Access library (what Access itself uses), whereas ADO is a more generic library (now superseded by the vastly different ADO.NET library.) Different versions of Access default to different libraries.With Access 2000, you can either link the table using ODBC or decide to take profit of the new Access Project file (.adp) using OLE-DB.In the link option, your Access-VBA code remains in DAO, but need to be adapted to the newly ODBC-linked tables.
Therefore you need to know the new primary key value for the new parent records. You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions.This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers questions, and eliminate the ads that are displayed to guests. Hi there, I have a fully updatable ADO recordset from SQL Server in my Access 2003 database.When you migrate Access data to SQL Server, you have two choices with Access 2000 and only one with other versions.With previous versions of Access, you will link SQL Server tables, using ODBC, to your Access database.