At 02:17 PM 08/25/2000, Paul Falzer wrote: >Brian Tift asked: >> I need to prevent users from seeing personal >> identifier variables (ie name, address, ssn, >> etc.) but Access does not support views, >> just queries. SAS does not seem to be able >> to read queries from access. Is there a >> way to limit the variables that user can >> retrieve from a table in access? > >What Access calls "queries" are actually views. You can easily >turn a view (or query if you wish) into a table with a "make >table" query. The best approach is to create a regular ("select") >query that includes the fields (or variables) that will appear in >the table. Once you are satisfied with the result, turn the >select query into a "make table" query.

See my posts froma few moments ago:

1) you can read Access "select" queries, you do *not* need to MAKE TABLE

2) there may be a bug in this however

HTH ---------------------------------------------------------------------------- William W. Viergever Voice : (916) 483-8398 Viergever & Associates Fax : (916) 486-1488 A SAS Institute Quality Partner (USA) E-mail : wwvierg@ibm.net Sacramento, CA 95825

"Only put off until tomorrow what you are willing to die having left undone." - Pablo Picasso

"God gives every bird his worm, but he does not throw it into the nest." - Swedish proverb ----------------------------------------------------------------------------