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.