Showing posts with label toan. Show all posts
Showing posts with label toan. Show all posts

Saturday, February 25, 2012

ODBC Secruity

I have set up a VB front end and use an ODBC to connect to
an SQL database. Is there a way were i can not allow a
user to simply connect to their ODBC link and Delete the
whole thing using access?If the user has access to the server and a login, there's not much you can
do to stop a particular method of accessing the server. If you application
lived on a web server, you could restrict access to the SQL Server from
only that machine using IPSec policies. But, there isn't a good way to
restrict access via ODBC or dbLibrary api for example.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.