Newbi - how to specify the location of a MS Access DB in the Manage Database Connections screen

david_e_monarch
david_e_monarch New Altair Community Member
edited November 2024 in Community Q&A

I have no trouble connecting to server databases such as Postgresql, but I cannot see where to specify the location of a MS Access database when I am creating a connection to it. I tried putting the path in the Database scheme text box, but that didn't work. 

 

I apologize if this is lower than a newbi question, but I cannot find an answer.  

 

 

Any advice or pointers would be greatly appreciated.

 

Thank you,

David

Best Answer

  • Thomas_Ott
    Thomas_Ott New Altair Community Member
    Answer ✓

    The Read Access operator is a but of unique operator as it was rebuilt a few years ago. I don't think you create connections via the Connection tab anymore,  you just select all location of the database from the database parameter on the operator itself. 

Answers

  • sgenzer
    sgenzer
    Altair Employee

    hello @david_e_monarch - welcome to the community. Hmm that's strange. Can you post a screenshot of your database connection screen so we can take a look?

     

    Scott

     

     

  • Thomas_Ott
    Thomas_Ott New Altair Community Member
    Answer ✓

    The Read Access operator is a but of unique operator as it was rebuilt a few years ago. I don't think you create connections via the Connection tab anymore,  you just select all location of the database from the database parameter on the operator itself. 

  • david_e_monarch
    david_e_monarch New Altair Community Member

    Here is the Connections Screen.  

     

    As a real newbi, I forgot to say that I am using version 8.0.001

  • david_e_monarch
    david_e_monarch New Altair Community Member

    You're correct.  I had been following along on the tutorial and did not look for this functionality in the Read Files group.  Still, I don't understand why there is a MS Access connection choice under connections if we should not use it.  Any thoughts on this?  :-)

  • Thomas_Ott
    Thomas_Ott New Altair Community Member

    No idea.