cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Dinakar978
‎09-01-2015
  • 3 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Missing tables when connecting to MS access through SAS

by Tourmaline | Level 20 in SAS Data Management
‎12-09-2014 10:07 AM
‎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? ... View more

Re: SAS connection to MS Access database

by Lapis Lazuli | Level 10 in SAS Programming
‎12-09-2014 08:46 AM
‎12-09-2014 08:46 AM
I haven't used Access in this way in a long while...but I think it had built-in permissions.  You could define permissions to select/update/etc. tables based on user id.  ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Quick links