Disabling ACC2000 ODBC pass-through queries....

=?Utf-8?B?bWF0dHlzZWx0eg==?=

Guest

Posts: n/a

22nd Jul 2005

All--
Is there a way to prevent someone who is using MS Access 2000 as a
front-end for an MS SQL Server 7 back-end from issuing passs-through queries?
I am concerned that it is far too easy for a knowledgeable user to issue a
DROP TABLE or TRUNCATE TABLE command indiscriminately and maliciously. As
this is an ODBC pass-through, is there a Registry key that can be disabled on
the user's pc?

TIA,

mattyselts

« Security Woes - how to best secure per group per table | Workgroup Connection Lost »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SQL syntax for Access Pass Through queries (ODBC)	mrazanaqvee	Microsoft Access	4	25th Jan 2010 01:46 PM
RE: MS-Access 2007 ODBC error with pass-through queries	JimP	Microsoft Access VBA Modules	0	27th Feb 2009 07:47 PM
ODBC to SQL 2005, pass through queries ask for password	nnn	Microsoft Access Form Coding	2	23rd Apr 2008 03:11 AM
ODBC Pass-Through Queries	=?Utf-8?B?QmxvY2tOaW5qYQ==?=	Microsoft Access Queries	2	16th Nov 2007 04:09 PM
Pass through queries vs Linked ODBC	=?Utf-8?B?a2FiYWth?=	Microsoft Access	4	4th Apr 2006 10:22 AM