We help IT Professionals succeed at work.

Linking Microsoft Access to Microsoft Dynamics.

I would like to use Access 2010 and link directly to Dynamics 2011 to view and make changes to service cases.  I know we can use an ODBC connection within Access to link directly to Dynamics SQL database, but I'm not sure what tables I need to be connecting to.  Can someone tell me what steps I need to take to link Access to Dynamics?

Thank you
Watch Question

Chinmay PatelChief Technology Ninja
Distinguished Expert 2019
Hi DataDudes,

It is NOT adviced to make changes to Dynamics CRM 2011 records by other means except the services. If you were to make any such changes tables you would connect to are IncidentBase and IncidentExtensionBase. What exactly you are trying to achieve here?

MIS Liason
Most Valuable Expert 2012
Whatever connection you make, it may not even allow edits (For the reasons Chinmay_Patel stated above), it may only provide you "Read Only " access.

<make changes to service cases.>
<but I'm not sure what tables I need to be connecting to.>
And neither do we.
Dynamics is an incredibly complex product and a term like "Service cases" is to braod for us to even begin to suggest what tables to link to or how to relate them.

If this is possible at all, ...your VAR (The company that sold, installed, configured,and supports your or Dynamics product) should be able to provide all of this information.


Explore More ContentExplore courses, solutions, and other research materials related to this topic.