Limiting Access to SQL Server by Application

From: Lindsay (lindsay.smith@lmco.com)
Date: 10/01/02


From: "Lindsay" <lindsay.smith@lmco.com>
Date: Tue, 1 Oct 2002 09:19:22 -0700


Is there anyway that access to a database on a SQL server
can be limited by application, meaning can I make it so
users can only view/update data through an Access front-
end via an ODBC interface but never see the tables even if
they have privileges to edit/update/add those tables and
install SQL software, such as the SQL Enterprise software
on their computer. They would not be able to see the
database through the SQL Enterprise software only through
Access and its ODBC.

Lindsay