topic Re: Missing tables when connecting to MS access through SAS in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Missing-tables-when-connecting-to-MS-access-through-SAS/m-p/142571#M2268 <HTML><HEAD></HEAD><BODY><P>Working with MS Access is not an everyday task for me, so just a few shots from the hip:</P><P> - Authorization/access rights?</P><P> - Table names does not comply with SAS naming conventions? (&lt;32 char, validvarname)</P><P>Access should support explicit SQL pass thru - can you access them that way?</P></BODY></HTML> Tue, 09 Dec 2014 15:07:02 GMT LinusH 2014-12-09T15:07:02Z Missing tables when connecting to MS access through SAS https://communities.sas.com/t5/SAS-Data-Management/Missing-tables-when-connecting-to-MS-access-through-SAS/m-p/142570#M2267 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #222222; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; background-color: #ffffff;">Hi Guys,</SPAN></P><P><SPAN style="color: #222222; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; background-color: #ffffff;">I would really appreciate if would could help with the problem I am facing when connecting to MS access database using pc sas. after i connect to the database, I am not able to all see all the tables/Queries that are in access database. Is there any reason why this would happen?</SPAN></P><P></P><P><SPAN style="color: #222222; font-family: 'Helvetica Neue', Arial, Helvetica, sans-serif; background-color: #ffffff;">Thanks in advance</SPAN></P></BODY></HTML> Tue, 09 Dec 2014 12:49:10 GMT https://communities.sas.com/t5/SAS-Data-Management/Missing-tables-when-connecting-to-MS-access-through-SAS/m-p/142570#M2267 Dinakar978 2014-12-09T12:49:10Z Re: Missing tables when connecting to MS access through SAS https://communities.sas.com/t5/SAS-Data-Management/Missing-tables-when-connecting-to-MS-access-through-SAS/m-p/142571#M2268 <HTML><HEAD></HEAD><BODY><P>Working with MS Access is not an everyday task for me, so just a few shots from the hip:</P><P> - Authorization/access rights?</P><P> - Table names does not comply with SAS naming conventions? (&lt;32 char, validvarname)</P><P>Access should support explicit SQL pass thru - can you access them that way?</P></BODY></HTML> Tue, 09 Dec 2014 15:07:02 GMT https://communities.sas.com/t5/SAS-Data-Management/Missing-tables-when-connecting-to-MS-access-through-SAS/m-p/142571#M2268 LinusH 2014-12-09T15:07:02Z