|
What are the steps-by-steps needed to modify a .adp (Access Data Project) file connection string and 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 the front-end aplication. Please note, I have used the Upsizing Wizard to create the .adp file to create a Client - Server application. Thanks.
(comments are locked)
|
|
From what I remember Access used to have a process known as the database splitter that does this very task. Sadly I have never used Access 2007 so cant confirm its still called that or still in the application. If it isnt then there is a downloadable utility called the Access Database Upsizer which does the same thing...http://office.microsoft.com/en-us/access/CH062526781033.aspx
(comments are locked)
|
