Microsoft Office 2000/Visual Basic Programmer's Guide   

Managing Client/Server Solution Security

An Access project file can't use the same user-level security features that an Access database file can. The data and other objects stored on your SQL Server can be fully secured by using SQL Server's security features. To secure server-side objects, use SQL Server's SQL Server Enterprise Manager, Transact-SQL statements, or the SQL Server Security dialog box in Access (Tools menu, Security submenu, Database Security command). For information about securing SQL Server databases, see SQL Server Books Online, or click the Help button in the Access SQL Server Security dialog box and the Help button in the properties dialog boxes displayed from the main dialog box.

To secure the objects stored in your Access project file, Access provides three features: