Variable name for Default Database Folder

M

Michael Haskett

Is it possible to use a variable (e.g. \\dfs folder\%
USERNAME%) for the default database folder? I have had
success doing this for Word, Excel, and PowerPoint, but
not with Access.

Any help would be greatly appreciated.
 
W

Wayne Morgan

You should be able to do it from code, perhaps in your startup form.

Application.SetOption "Default Database Directory", "\\dfs_folder\" & Environ("username")
 
Top