Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

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

2 views
Skip to first unread message

Mander

unread,
Apr 11, 2010, 10:41:01 PM4/11/10
to
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

unread,
Apr 11, 2010, 10:54:01 PM4/11/10
to

Argyronet

unread,
Apr 15, 2010, 3:51:02 AM4/15/10
to
Hi,

If you are able to read french articles, I wrote this one :
http://argyronet.developpez.com/office/access/mdb2adp/
Perhaps it could help you...
--
Argy
Goto : http://argyronet.developpez.com/
Livres :
Créez des programmes avec Microsoft Access 2007 (ISBN 2742982442)
VBA pour Office 2007 (ISBN 2742983910)

0 new messages