Variable name for Default Database Folder

[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.

 

[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")