"jkm911" wrote:

> I'm using Access as a frontend Client for a SQL Server based application. 
> The Access Client is converted to an mde file and users can't access or view
> the content due to appropriate database properties setting and startup
> options.
>
> However, they can open a blank Access database and import passthru queries
> from my Client.  The imported queries contain the ODBC connection string in
> the querie properties box.  They can then use this ODBC connection string to
> gain access to the SQL data.
>
> How can I prevent this?
>
> Thanks in advance.
>
> jkm911

"jkm911" <jkm***@discussions.microsoft.com> wrote in message
news:C4AA0A80-AE51-4D66-9EE7-76F29EDF49F4@microsoft.com...
> I'm using Access as a frontend Client for a SQL Server based application.
> The Access Client is converted to an mde file and users can't access or
> view
> the content due to appropriate database properties setting and startup
> options.
>
> However, they can open a blank Access database and import passthru queries
> from my Client.  The imported queries contain the ODBC connection string
> in
> the querie properties box.  They can then use this ODBC connection string
> to
> gain access to the SQL data.
>
> How can I prevent this?
>
> Thanks in advance.
>
> jkm911