Hi everyone,
I have an ODBC connection in Microsoft Access to download data from a SQL
server. One problem is that the Import Object window will display not just
the databse tables that I want to download, but it also lists all the
Information_Schema tables and the sys tables. I would like to disable the
display of the Information_Schema and sys tables because this ODBC connection
will be used by users that do not need to know the system information on SQL.
The SQL login of this ODBC connection currently is in the "guest" group, and
have a "public" checked under "server roles." I tried to uncheck the "server
roles" but it would not let me. Can anyone let me know how to hide sys files
and information_schema files from the user?
Thanks a lot!
>> Stay informed about: hide sys files from ODBC connection