News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Friday, November 25, 2005

How to deploy Access project (ADP)

Once you ready to deploy a new version of your Access project (ADP/ADE) – you should delete existing connection string, else, when Access starts the project on client’s PC - it will produce a message that it can not connect to SQL Server. The trick – is to clear connection string using Application.CurrentProject.OpenConnection "". Also you can look at Microsoft KB article How to deploy an Access 2003 project that connects to an existing SQL Server 2000 database for more details on ADP deployment.


Anonymous Anonymous said...

Thank you!

7:56 PM  

Post a Comment

<< Home