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.
 
You must log in or register to reply here.

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
Adodb connection to different SQL SERVER DB 3
What's the steps to modify a .adp connect string & convert DAO to 2
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 2007 and ADP to SQL Server 2005 in Vista 12

Back
Top