Connect DOMO to Table in MS Access Database Saved to Local Hard Drive

Hello,

 

I've read the existing "asked and answered" post on this subject but am still at a loss in understanding what should be (?) a simple connection to an existing table in a locally-stored MS Access database.  I can create a .dsn file to the database but am unable to point to it using a DOMO connector and/or Workbench.  Can anyone provide additional guidance on this topic?

Sincere thanks,

Kem

Comments

  • DaniBoy
    DaniBoy

    domo

    💎

    Can you post a link to the article or post you read so we know what you are referring to?

    Thanks!

    Dani aka "Mr.Dojo"

    Dojo Admin
    **Say "Thanks" by clicking the "heart" in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
    **You can update your Dojo Community name and avatar by clicking on your avatar then the "My Profile" button.
  • Hello @user11319 ,

     

    The Cloud Connector for Access is SFTP connections only, so you will use Workbench and connect through the ODBC driver to query the tables stored locally. For more info, Check out this post in Dojo for the solution

    Jacob Folsom
    **Say “Thanks” by clicking the “heart” in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Hi - the link that DataJake provided is the previous asked/answered that I referenced before.

    Thank you,

    Kem