Access 2.0 converting to 2003 AND linked table manager

[dgillz]

I have several MS Access 2.0 applications that I converted to Access 2003. Immediately after the conversion I attempted to use the linked table manager to change several linked btrieve 6.15 files to an ODBC DSN which is pointed to my MS SQL Server. However I do not have an option to do this, it is only asking for the location of the btrieve file, I am not getting the option to actually change the data source.

I can link new tables to the Access app using the same DSN without an issue, can query these tables, etc., but the btrieve linked tables are not allowing me to change to an ODBC DSN.

Any insights appreciated.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[PHV]

This may be of interest for you:

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

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886