SQL Server Connection string in Access ADP program?

  • Thread starter Thread starter Al Franz
  • Start date Start date
A

Al Franz

Can you change a SQL Server Connection string in an ADP program by possibly
using something like a drop down box.
 
Hi Sylvain,

Al is my friend and he posted this for me. I have used the
CloseConnection and OpenConnection code before but used to get error
on the CloseConnection.

After reading these posts, I took out the CloseConnection but now the
OpenConnection gives this error.

-2003764257: Method 'OpenConnection' of object '_CurrentProject'
failed

I am using Access 2007 ADP to connect to SQL Server 2005 on the same
box. i.e Trusted Connection.

Please advise.

Thanks.
 
Sorry but I don't use A2007 so I have no idea about it or about any problem
with this version.
 

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

Call stored procedure in SSMS from Access 2016 doesn't work. 0
What's the steps to modify a .adp connect string & convert DAO to 2
Adodb connection to different SQL SERVER DB 3
Security Hole in ADO Connection from ADP to SQL Server 19
Access 2007 ADP project will not connect to SQL Server 2008 2
Create ADP using 2007 under Vista fails 7
Future of ADP - new article 12
Access 2000 ADP and SQL Server 2005 2

Back
Top