My client has a mission-critical application that was written in
Microsoft Access sitting on a SQL Server database. It is basically a
Quotation management system. The client wishes to install CRM and I'm
investigating how to migrate the Customer data from their Quotation
system to CRM. I'm pretty confident I can do this without too much
trouble (having identified the relevant tables in CRM - AccountBase
and ContactBase). However, I then want to link directly to the CRM
tables from within the Access application. Normally I'd do this by
setting up a DSN and using it to pull in links to the required
tables. I've set up a DSN to connect to the CRM data, but when I try
to link to the tables they don't appear in the list of available
tables.
Has anyone any experience of using ODBC to link external applications
to CRM?
Thanks
Edward
