ODBC dsn file

aspfun

Registered User.
Local time
Yesterday, 23:50
Joined
Apr 22, 2006
Messages
29
I use dsn file as below from Access to link to SQL server via ODBC.
From Access, I use this file but list all tables including system tables. How to restrict system objecs?

[ODBC]
DRIVER=SQL Server
UID=aspfun
Trusted_Connection=Yes
DATABASE=credent
WSID=aspfun_ws
APP=Microsoft Data Access Components
SERVER=order
 
Do you by change have "System Objects" checked in Tools -> Options? I'm not sure if that affects linked tables or not. If that's not it, then it's going to be at the source, and not controllable at the Access level. To avoid system objects without touching the server, you'd link each table individually.
 

Users who are viewing this thread

Back
Top Bottom