topic Re: SAS connection to MS Access database in SAS Programming https://communities.sas.com/t5/SAS-Programming/SAS-connection-to-MS-Access-database/m-p/141550#M261574 <HTML><HEAD></HEAD><BODY><P>You can check any embedded permission...as well as table names to ensure SAS compatibility.</P></BODY></HTML> Mon, 08 Dec 2014 19:05:09 GMT DBailey 2014-12-08T19:05:09Z SAS connection to MS Access database https://communities.sas.com/t5/SAS-Programming/SAS-connection-to-MS-Access-database/m-p/141549#M261573 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P>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. </P><P>Any ideas on why all the tables are not being shown and how to correct this issue.</P><P></P><P>Thanks,</P><P>Dinakar</P></BODY></HTML> Mon, 08 Dec 2014 18:23:59 GMT https://communities.sas.com/t5/SAS-Programming/SAS-connection-to-MS-Access-database/m-p/141549#M261573 Dinakar978 2014-12-08T18:23:59Z Re: SAS connection to MS Access database https://communities.sas.com/t5/SAS-Programming/SAS-connection-to-MS-Access-database/m-p/141550#M261574 <HTML><HEAD></HEAD><BODY><P>You can check any embedded permission...as well as table names to ensure SAS compatibility.</P></BODY></HTML> Mon, 08 Dec 2014 19:05:09 GMT https://communities.sas.com/t5/SAS-Programming/SAS-connection-to-MS-Access-database/m-p/141550#M261574 DBailey 2014-12-08T19:05:09Z Re: SAS connection to MS Access database https://communities.sas.com/t5/SAS-Programming/SAS-connection-to-MS-Access-database/m-p/141551#M261575 <HTML><HEAD></HEAD><BODY><P>Hi Bailey,</P><P>I am very new to this, Could you please elaborate on what you mean by embedded permission?</P><P></P><P>Thanks,</P><P>Dinakar</P></BODY></HTML> Mon, 08 Dec 2014 19:25:44 GMT https://communities.sas.com/t5/SAS-Programming/SAS-connection-to-MS-Access-database/m-p/141551#M261575 Dinakar978 2014-12-08T19:25:44Z Re: SAS connection to MS Access database https://communities.sas.com/t5/SAS-Programming/SAS-connection-to-MS-Access-database/m-p/141552#M261576 <HTML><HEAD></HEAD><BODY><P>I haven't used Access in this way in a long while...but I think it had built-in permissions.&nbsp; You could define permissions to select/update/etc. tables based on user id.&nbsp; </P></BODY></HTML> Tue, 09 Dec 2014 13:46:13 GMT https://communities.sas.com/t5/SAS-Programming/SAS-connection-to-MS-Access-database/m-p/141552#M261576 DBailey 2014-12-09T13:46:13Z