Connecting to a Secured Access Database Problem You want to connect to a Microsoft Access database that has been secured with user-level security and a workgroup file. Solution Use the Jet OLEDB:System Database attribute in the connection string to specify the path and filename of the workgroup information file or system database. | Team LiB Team LiB Recipe Connecting to a Secured Access Database Problem You want to connect to a Microsoft Access database that has been secured with user-level security and a workgroup file. Solution Use the Jet OLEDB System Database attribute in the connection string to specify the path and filename of the workgroup information file or system database. The sample code contains a single event handler Connect Creates and opens a connection to a Microsoft Access database secured with userlevel security and a workgroup file using the OLE DB .NET data provider. Information about the database is displayed from the properties of the OleDbConnection object. The C code is shown in Example 1-4. Example 1-4. File Namespaces variables and constants using System using using using . . . private void connectButton_Click object sender e StringBuilder result new StringBuilder Build the connection string with security information. String connectionString MsAccess_ConnectString @ Jet OLEDB System database Team LiB MsAccess_SecureMdw_Filename User ID Password- connectionString Create the connection. OleDbConnection conn new OleDbConnection connectionString try Attempt to open the connection. Connection State OLE DB Provider Server Version Connection State catch ex ERROR Discussion Microsoft Access user-level security requires an additional file the workgroup information or MDW file in addition to the database or MDB file. This file contains the .
