Connect to .mdb or sql server option? 1

[leobaby]

Hopefully someone has tried this before or has some useful suggestions.

I am trying to create a database that will connect to a .mdb back end or an sql server. I have two parallel versions, but keeping them up to date with each other is a nightmare. For the sql version I am using odbc linked tables.

I envision a form with a combo that lets you choose mdb or sql. If you choose mdb, it visibles the path box and browse button (I have already implemented code that uses .refreshlink after browsing for file); If you chose sql, it presents the server, login and pw fields necessary to connect.

Also, for the sql version, my implementation of the data source selection isn't Nearly as robust as the 'Select data source / Create New Data Source' dialogs found in the linked table manager. Surely someone has found a way to implement or mimick these in their database?


Obviously, any help is appreciated.
Many thanks in advance.
Matthew

 

[colinb]

Could you not just have both sets of tables permanently linked, and prefix the Access ones with, say mdb_ and the SQL Server ones with say sql_?

That way the Queries could be built on-the-fly to connect to the selected tables.

This also simplifies the syncronising of the two sets of tables.