Change Connection from Sql to Access

[TaylorTot]

Hello,

I'm not sure if I am in the right forum, but here it goes. . .

I am using Access 2000 and am having trouble programatically changing the connection string from sql tables to access tables.

I was successful in updating the connection from sql to sql or access to access, but cannot figure out the vb for sql to access?

Thank you for any help you can provide!

 

[PHV]

You may have a look here:

http://www.mvps.org/access/tables/tbl0009.htm

http://www.connectionstrings.com/

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886