Forum Discussion

DaneelsMedia's avatar
DaneelsMedia
Copper Contributor
Apr 23, 2020

Trying to find out how to report an Access problem to support / or trying to find a solution

Hi all, I am new to the communities although I am a long time MS user, so here goes.   Over 6 months ago we ran into a problem the built in salesforce connector of Access. First release we noticed ...
access
tsgiannis's avatar
tsgiannis
Iron Contributor
Apr 28, 2020

DaneelsMedia have you checked if using a Pass through query maps correctly the fields .

Maybe you could create a PT ...retrieve some data and then use a make table to create a local (temp) table.

Check if the sizes now are correct

  • DaneelsMedia's avatar
    DaneelsMedia
    Copper Contributor
    Apr 29, 2020

    tsgiannis I don't think I fully understand your suggestion, where would my pass through query go? To an SQL server but that server doesn"t have access to the salesforce data? Doing a passthrough to salesforce direct? Don't think that is possible.

     

    Please advice if I am overlooking something.

     

    Peter

     

    • tsgiannis's avatar
      tsgiannis
      Iron Contributor
      Apr 29, 2020

      DaneelsMedia Let me understand something because from screenshots is not that clear.

      When you work from Access "to" SalesForce  you work with 

      1. Linked tables ( i saw some on the screenshots )
      2. Pass through Queries
      3. Some API way ... it would be really interesting to share some info if that is the case
      4. Some other way... i suspect from your response that probably SalesForce exports the data to something like .csv or similar and you import them

      In both cases 1 & 2 you need a driver to connect to SalesForce BE whatever that might be...if not and you are falling to cases 3 & 4 maybe SalesForce exports the data correctly but the importing module fails for some reason to recognize the datatype's length and doubles everything...(maybe something like 32bit-64bit)

      It seems that SalesForce doesn't provide an ODBC driver (that's why the mixup...i saw the headlines ) but there are vendors providing ODBC drivers : https://success.salesforce.com/ideaview?id=08730000000BqquAAC so you might want to consider buying one.

      • DaneelsMedia's avatar
        DaneelsMedia
        Copper Contributor
        Apr 29, 2020

        tsgiannis Regarding you tech part of the question:

        In our version of Access (we have an O365 E3 license) there is as standard (when you want to setup an external data source)  a Salesforce connector. This connector is NOT part of all version of O365 Access.

         

        https://support.office.com/en-us/article/link-to-or-import-data-from-salesforce-7375ffb6-1d6a-46f1-bb0c-c6ac3c58f5a0

         

        This allows to access the Salesforce  objects as linked (or copied) tables in our applications. You can do almost everything (select, insert, delete...) with the right permissions, so it really fits our case (provided it works of course :smile:).

         

Resources