Distributing Access ADP

S

SPSSG

Is there anyway to change the Connection properties in
Access Project programatically. Basically, I have a
problem where I am developing or modifying Access
projects in my test environment with a connection to my
SQL Server. When I distribute it to the client in a run-
time environment the settings for my SQL Server is still
embedded in the Access adp. I then have to attach my
laptop to their network, open the Access adp on my laptop
and change the Connection settings. Is there an easier
method to deploy the ADP to connect to different SQL
Servers?
 

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. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can't send emails on new PC 1
Publisher 2019 Format Picture window size too large to display OK button 0
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Excell Otpions in office environment 0
A couple questions BEFORE using Office 365 0
How can I install Publisher in 365 Enterprise? 1

Top