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.
This is a JMP forum, not so much a SAS forum. You might consider posting your question over at http://communities.sas.com, perhaps in the Data Management section: Community: Data Management | Communities on SAS.
If you have JMP, you could try accessing the Microsoft Access tables from JMP's Database > Open Table feature and see if you have the same issue.