Change Connection String from SQL to Access

  • Thread starter Thread starter Michelle
  • Start date Start date
M

Michelle

Hello,

I am trying to programatically change my connection string from sql to
access.

I have been successful changing the connection string from sql to sql
or access to access, but not sql to access.

Thank you for your help in advance!
 
I don't think that'll work, Norman, as you cannot connect to a Jet database
from Access using ODBC, while you have to use ODBC to connect to SQL.

Michelle: Easiest is probably to create a list of the existing linked tables
(in an array, a collection, or a table), delete the existing linked tables,
then use TransferDatabase to create new linked tables.
 
I don't think that'll work, Norman, as you cannot connect to a Jet database
from Access using ODBC, while you have to use ODBC to connect to SQL.

Michelle: Easiest is probably to create a list of the existing linked tables
(in an array, a collection, or a table), delete the existing linked tables,
then use TransferDatabase to create new linked tables.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no e-mails, please!)







- Show quoted text -
Click to expand...

That's what I have been doing, I was just wondering if there was an
easier/more efficient way of doing this. Thank you for your help.
 
Back
Top