BookmarkSubscribeRSS Feed
Dinakar978
Calcite | Level 5

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

3 REPLIES 3
DBailey
Lapis Lazuli | Level 10

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

Dinakar978
Calcite | Level 5

Hi Bailey,

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

Thanks,

Dinakar

DBailey
Lapis Lazuli | Level 10

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. 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 965 views
  • 0 likes
  • 2 in conversation