What's the steps to modify a .adp connect string & convert DAO to

Discussion in 'Server Migration' started by Mander, Apr 12, 2010.

  1. Mander

    Mander Guest

    What are the steps needed to modify a .adp (Access Data Project) file
    connection string to point to a SQL Server database? Also how and where
    do I go to convert the DAO (Data Access Object) code to it's equivalent
    ADO (ActiveX Data Objects)? I'm converting a MS Access2007 database project
    to SQL Svr2005 back-end and wish to have Access2007 remain as the front-end
    aplication. Please note, I have used the Upsizing Wizard to create the .adp
    file to create a Client - Server application.
    Mander, Apr 12, 2010
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.