 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / July 2007Access 2007 - how to change the "Get External Data" default directory?
Access 2007 Hopfully, there is a way to change this default directory. The last used directory, does not have the permanency I would like but, is much better than MS's attempt to force all users to begin in a meaningless User directory to 99% of users. TIA EagleOne > Access 2007 > [quoted text clipped - 5 lines] > > TIA EagleOne Click the round Office logo button in the upper left corner of the Access window, then the Access Options button near the lower right corner of the drop-down menu. This will display the Access Options dialog box, and one of the options there is 'Default database folder'.  SignatureBrendan Reynolds On Jul 27, 10:06 am, "Brendan Reynolds" <brenr...@discussions.microsoft.com> wrote: > > Access 2007 > > > Hopfully, there is a way to change this default directory. Thanks Brendan, That option for the 'Default database folder' was changed. I am refering to the "Get External Data" default directory > > The last used directory, does not have the permanency I would like > > but, is much better than MS's attempt to force all users to begin in a [quoted text clipped - 9 lines] > -- > Brendan Reynolds > On Jul 27, 10:06 am, "Brendan Reynolds" > <brenr...@discussions.microsoft.com> wrote: [quoted text clipped - 8 lines] > > I am refering to the "Get External Data" default directory In my tests, the folder I chose as the default database folder was also used when I selected Get External Data. Did that not happen for you? SignatureBrendan Reynolds >> On Jul 27, 10:06 am, "Brendan Reynolds" >> <brenr...@discussions.microsoft.com> wrote: [quoted text clipped - 11 lines] > In my tests, the folder I chose as the default database folder was also > used when I selected Get External Data. Did that not happen for you? Some further testing indicates that you may need to close and re-open Access before the change sticks. SignatureBrendan Reynolds On Jul 27, 10:42 am, "Brendan Reynolds" <brenr...@discussions.microsoft.com> wrote: > >> On Jul 27, 10:06 am, "Brendan Reynolds" > >> <brenr...@discussions.microsoft.com> wrote: [quoted text clipped - 9 lines] > > >> That option for the 'Default database folder' was changed. Brenden, are you using Access 2007? > >> I am refering to the "Get External Data" default directory > [quoted text clipped - 8 lines] > > - Show quoted text - On Jul 27, 10:42 am, "Brendan Reynolds" <brenr...@discussions.microsoft.com> wrote: > >> On Jul 27, 10:06 am, "Brendan Reynolds" > >> <brenr...@discussions.microsoft.com> wrote: [quoted text clipped - 9 lines] > > >> That option for the 'Default database folder' was changed. Ah Ha! If I choose import "Access" then I get my default choice. If I choose import "Excel" then i get C:\Users\"my name"\Documents\. is there a Registry entry which could be made to change it to my default directory? Dennis > >> I am refering to the "Get External Data" default directory > [quoted text clipped - 8 lines] > > - Show quoted text - <snip> > Ah Ha! > [quoted text clipped - 3 lines] > is there a Registry entry which could be made to change it to my > default directory? Probably, but I'm afraid I don't know which entry that would be. I tried changing the default folder within Excel, to see if Access would use that folder, but apparently it does not. SignatureBrendan Reynolds |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.