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.