https://communities.sas.com/t5/SAS-Procedures/Libname-Microsoft-Access/m-p/73970#M21429 When I create a libname to my ms access db it only shows me the tables not the queries. Can this be changed? <BR /> <BR /> I have created some view tables within microsoft access and the only way to do that is with a query. I need to be able to view that ms access view table in sas.<BR /> <BR /> Thank you Thu, 01 Oct 2009 16:50:24 GMT jerry898969 2009-10-01T16:50:24Z https://communities.sas.com/t5/SAS-Procedures/Libname-Microsoft-Access/m-p/73970#M21429 When I create a libname to my ms access db it only shows me the tables not the queries. Can this be changed? <BR /> <BR /> I have created some view tables within microsoft access and the only way to do that is with a query. I need to be able to view that ms access view table in sas.<BR /> <BR /> Thank you Thu, 01 Oct 2009 16:50:24 GMT https://communities.sas.com/t5/SAS-Procedures/Libname-Microsoft-Access/m-p/73970#M21429 jerry898969 2009-10-01T16:50:24Z https://communities.sas.com/t5/SAS-Procedures/Libname-Microsoft-Access/m-p/73971#M21430 I fix that issue by using the correct DB. <BR /> <BR /> Sorry I wanted to delete the post not sure how. Thu, 01 Oct 2009 17:01:55 GMT https://communities.sas.com/t5/SAS-Procedures/Libname-Microsoft-Access/m-p/73971#M21430 jerry898969 2009-10-01T17:01:55Z