ADP security

  • Thread starter Thread starter Jane
  • Start date Start date
J

Jane

Hello,

Is there a way to set up a password-protected ADP (access
data project)?

Thanks in advance
Jane
 
Jane,

Not as far as I know.

If you're running an ADP, security is handled by SQL Server. If you want to
manage security on the client, you'll have to implement it yourself in VBA.
You still have access to macros, so you can create an AutoExec macro which
fires up a "database password" form, but since macros can be bypassed, it
won't be foolproof.

I'd recommend using SQL Server security. If a user doesn't have permission
to access the SQL Server database, they won't have permission to do anything
meaningful with the ADP.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html
 
Back
Top