Secure an adp file?

  • Thread starter anthony.mescall
  • Start date
A

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??
 
S

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.
 
A

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.
 
G

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??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top