Change default folder in Access using VBA

  • Thread starter Thread starter Russell Farr
  • Start date Start date
R

Russell Farr

Hi

I was wondering if there is a way to write in VBA a
procedure to change the default database folder (found
under Options/General tab in Access menus).

I look forward to hearing from you

Thanks

Russell Farr
 
Hi Russel,

Within VBA use the following code and replace c:\projects with your own folder

SetOption "Default Database Directory", "c:\projects"

Hope this helps
 
Back
Top