USING THE SECURED SAMPLE DATABASE: CHAP21S.MDB

The Chap21.mdb file provided on the accompanying CD-ROM is a totally unsecured database with all the code examples in this chapter. There's also a totally secured version of this database, Chap21s.mdb, provided for your use. To access this database, you need to join the Apsystem.mdw workgroup information file also provided in the ExamplesChap21 folder on the CD-ROM.

The following users and groups have been created in Apsystem.mdb and are referenced here so that you can re-create the accounts:

User: Jennifer

PID: L1a2B3r4I5e

Password: <none>

User: Ryan

PID: jS6uP9nU2e

Password: MySecret

User: Scott

PID: B1a2R3k4E5r

Password: Developer

Group: Managers

PID: S1e2C3r4E5t

Group: Employees

PID: A1c2C3e4S5s

In addition to these users and groups, the workgroup information file, Apsystem.mdw, was created with the following settings:

Name: F. Scott Barker

Company: Applications Plus

Workgroup ID: W1o2R3k4G5r6O7u8P

The original Admin that came with the workgroup information file has the following settings:

User: Admin

PID: <global across all versions of Access>

Password: a

Try opening Chap21s.mdb while logged on to your own workgroup information file and see what happens. Then try joining Apsystem.mdw and logging on as one of the provided users. Notice which users can see the code.