• System Integration 51
  • NEWBIE
  • 0 Points
  • Member since 2018

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
I am trying to connect Microsoft Access (from Office 365) to salesforce.  I have followed the instructions in the following link:
https://support.office.com/en-us/article/link-to-or-import-data-from-salesforce-7375ffb6-1d6a-46f1-bb0c-c6ac3c58f5a0

When I attempt to link a new table to Salesforce, I use my credentials in the Connect to Salesforce login.  Then I get a linked tables dialog, in which all the Salesforce objects are listed.  I choose one, then get the following error:

The Microsoft Access database engine could not find the object MyOrg..Pricebook2.  Make sure the object exists and that you spell its name and the path name correctly.  If MyOrg..Pricebook2 is not a local object, check your network connection or contact the server administrator

I have enabled the Use Any API Client permission for myself.  However, in the Connected App persmissions, I haven't been able to find anything I can identify as what Microsoft Access is using.  This might be a clue.

Thanks for anyone's help!