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
