Secure an adp file?

[anthony.mescall]

I have an adp file which I want to be accessed using forms only for
security reasons. I have a front end which closes off underlying
Access
window, but it is still possible to connect to the underlying adp via a
second mdb file. In Access mdb, encryption was possible - what can be
done
with an adp file to restrict access via a linked file. It looks like
Microsoft reduced security options for adp files, presumably to rely in
SQL access rights??

 

[Sylvain Lafontaine]

You're right, ADP is only one of all the possible ways of connecting to
SQL-Server.

By restricting some of the access to the tables with Views and Stored
Procedures, you can achieve a greater level of security; however, you will
always be limited by the fact that you don't have access to an UpdateCommand
for linked forms in ADP.

The only way of achieving a very high level of security is by using unbound
forms and doing all the calls yourself or using another technology such as
..NET.

 

[aaron.kempf]

i thought that you could setup an 'application role' in sql server that
will prohibit anything with the appname <> 'Microsoft Office Access'
from connecting to the db.

i swear i've seen something like that.

 

[Guest]

access to what would you like to restrict?

1) Tables with underlying data, or
2) query / stored procedure definitions, or
3) Form / Report design??