Missing tables when connecting to MS access through SAS

[Dinakar978]

Hi Guys,

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?

Thanks in advance

[LinusH]

Working with MS Access is not an everyday task for me, so just a few shots from the hip:

- Authorization/access rights?

- Table names does not comply with SAS naming conventions? (<32 char, validvarname)

Access should support explicit SQL pass thru - can you access them that way?