IniPath Property

Applies To

DBEngine object.

Description

Sets or returns information about the Windows Registry key that contains values for the Microsoft Jet database engine (Microsoft Jet workspaces only).

Settings and Return Values

The setting or return value is a String data type that points to a user-supplied portion of the Windows Registry key containing Microsoft Jet database engine settings or parameters needed for installable ISAM databases.

Remarks

You can configure the Microsoft Jet engine with the Windows Registry. You can use the Registry to set options, such as installable ISAM DLLs.

For this option to have any effect, you must set the IniPath property before your application invokes any other DAO code. The scope of this setting is limited to your application and can't be changed without restarting your application.

You also use the Registry to provide initialization parameters for some installable ISAM database drivers. For example, to use Paradox version 4.0, set the IniPath property to a part of the Registry containing the appropriate parameters.

This property recognizes either HKEY_LOCAL_MACHINE or HKEY_LOCAL_USER. If no root key is supplied, the default is HKEY_LOCAL_MACHINE.

Microsoft Jet versions 2.5 or earlier kept initialization information
in .ini files.

See Also

SystemDB property.

Example

This example sets the path in the IniPath property to an application's key in the Windows Registry.

Sub IniPathX()

    ' Change the IniPath property to point to a different
    ' section of the Windows Registry for settings
    ' information.
    Debug.Print "Original IniPath setting = " & _
        IIf(DBEngine.IniPath = "", "[Empty]", _
        DBEngine.IniPath)
    DBEngine.IniPath = _
        "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft" & _
        "\Jet\3.5\ISAM Formats\FoxPro 3.0"
    Debug.Print "New IniPath setting = " & _
        IIf(DBEngine.IniPath = "", "[Empty]", _
        DBEngine.IniPath)

End Sub