How to prohibit Users from importing Queries from my database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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
Click to expand...

Is the SQL back end path not password protected? If it is then remove it
from the connection string.

Keith.
www.keithwilby.com
 
Back
Top