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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Shortcuts for VBA procedures in Modules of MS Access 5
Changing Access Options by Code 2
MS Access - Form - Upload document to Sharepoint Server (whoes folder is mapped to my PC) from Acce 0
Creating Access menus using VBA 1
access default database folder for all users 3
Set Access to Always Show Full Menus 7
How to open a file in its default application using VBA. 5
Access Access 2007 "export" default destination folder 0

Back
Top