Linked Tables - Access Front End, Access AND SQL Backends

[Scott A. Jones]

Hello,

I've got a Access application (front end) that needs to link to two data
sets: SQL Server and Access MDB. I frequently have to make enhancements to
the front end, so have decided to automate table linking through code so
that I can streamline the delivery of updates to the client.

I've found code for linking both DNS-Less SQL connections and Access MDB
connections. My problem is that my DNS-Less connection code (found at
http://members.rogers.com/douglas.j.steele/DSNLessLinks.html) messes up my
MDB linked tables. It doesn't differentiate between MDB linked tables and
SQL linked tables. It assumes that all tables are SQL linked tables.

Does anybody know how to either:

a) automate linked tables between both data sources without causing
conflicts?

or

b) fix the code in the above link to ONLY process SQL linked tables?

Any assistance will be GREATLY appreciated.

Thanks!
Scott A. Jones

 

[david epsom dot com dot au]

I have to parse the connect string anyway, to get the
foreign table names, so I can just check to see if the
string starts with ODBC; or ;Database= or something else.

(david)

 

[Scott A. Jones]

David,

That worked great!

Do you happen to have code that checks to see if the SQL Server/database is
running? I'd like to build some error-checking into my function.

Thanks,
Scott

 

[david epsom dot com dot au]

checks to see if the SQL Server/database is running

No, nothing like that -- go ahead and post it here
when you get it working :~)

(david)