Dynamically build connection objects for MSAccess databases

• silverstream

  Newbie

  Points: 1

  More actions

  March 21, 2011 at 1:03 pm

  #247299

  Dear Community,

  I have a task of connecting to several hundreds of MSAccess 97 databases and I tried following the tip from Hal Hayes article: http://www.mssqltips.com/tip.asp?tip=1437 However, on SQL Server 2008 I get a msg that I cannot pass an object as a variable.

  any suggestions?

  R

• Phil Parkin

  SSC Guru

  Points: 247180

  More actions

  March 21, 2011 at 1:23 pm

  #1301529

  Please post the full text of the error.

  Which component is the cause of the error?

  Please post the formulas for the expressions you have used.

  --Edit: for those who are too lazy to cut & paste, here is the above URL as a link.

  ---