How do I Referrence Specific Table

[bconner]

How do I referrence a specific table by name to change the connection string?

I have tried

[tblatb].Connect = "ODBC;DRIVER=SQL Server;SERVER=addwddtls7b1\billinganalytic2;Trusted_Connection=No;Database=DeepDiveGroup5;uid=admin;pwd=admin;"

 

[The_Doc_Man]

That ought to work, but try Tables("tablename").Connect to see if it is any better.