SAS connection to MS Access database

Reply
New Contributor
Posts: 3

SAS connection to MS Access database

Hi guys,

I am trying to connect to MS access database from PC Sas. I am able to connect but i am able to see only few tables, not all the tables for some reason.

Any ideas on why all the tables are not being shown and how to correct this issue.

Thanks,

Dinakar

Super Contributor
Posts: 578

Re: SAS connection to MS Access database

You can check any embedded permission...as well as table names to ensure SAS compatibility.

New Contributor
Posts: 3

Re: SAS connection to MS Access database

Hi Bailey,

I am very new to this, Could you please elaborate on what you mean by embedded permission?

Thanks,

Dinakar

Super Contributor
Posts: 578

Re: SAS connection to MS Access database

I haven't used Access in this way in a long while...but I think it had built-in permissions.  You could define permissions to select/update/etc. tables based on user id. 

Ask a Question
Discussion stats
  • 3 replies
  • 165 views
  • 0 likes
  • 2 in conversation