SQL Server Connection string in Access ADP program?

A

Al Franz

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

ishw4r

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.
 
S

Sylvain Lafontaine

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
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 and ADP to SQL Server 2005 in Vista 12
Access 2000 ADP and SQL Server 2005 2
Can't connect to local SQL Server 2005 from .adp 7
SQL Server 2005 schema for Access 2007 ADP 2

Top