Variable name for Default Database Folder

  • Thread starter Thread starter Michael Haskett
  • Start date Start date
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.
 
You should be able to do it from code, perhaps in your startup form.

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