Access Default Directory

[121854]

Could I dynamically, retrieve the Default Database Directory for a database. Ex. Tools | Options | General tab | Default Database Directory

Can someone share the VBA code or refer me to an article that provide me the necessary detail information to for the coding.

Than you.

 

[PHV]

A starting point:
MsgBox Application.GetOption("Default Database Directory")

Have a look here:

http://msdn.microsoft.com/library/en-us/off2000/html/achowSettingOptionsFromVisualBasic.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886