How to prohibit Users from importing Queries from my database

[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

 

[Guest]

Go to Tools,Security and set a database password.

 

[Keith Wilby]

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

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

Keith.
www.keithwilby.com