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

david_e_monarch

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

Thomas_Ott

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. 

sgenzer

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

 

 

david_e_monarch

Here is the Connections Screen.  

 

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

david_e_monarch

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

No idea.