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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment