12-09-2014 07:49 AM
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
12-09-2014 10:07 AM
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?