SystemDB Property (DAO)

Microsoft DAO 3.60

SystemDB Property

           

Sets or returns the path for the current location of the workgroup information file (Microsoft Jet workspaces only).

Settings and Return Values

The setting or return value is a String describing the fully resolved path to the workgroup information file.

Remarks

The Microsoft Jet database engine allows you to define a workgroup and set different access permissions to each object in the database for each user in the workgroup. The workgroup is defined by the workgroup information file, typically called "system.mdw". For users to gain access to the secured objects in your database, DAO must have the location of this workgroup information file. The location can be identified to DAO either by specifying it in the Windows Registry or by setting the SystemDB property. On setup, the default setting is simply "system.mdw" with no path.

For this option to have any effect, you must set the SystemDB property before your application initializes the DBEngine object (that is, before creating an instance of any other DAO object). The scope of this setting is limited to your application and can't be changed without restarting your application.