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.
 
Back
Top