Access 2007 - how to change the "Get External Data" default directory?

D

Dennis

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
 
B

Brendan Reynolds

Dennis said:
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
Click to expand...


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'.
 
D

Dennis

Thanks Brendan,

That option for the 'Default database folder' was changed.

I am refering to the "Get External Data" default directory
 
B

Brendan Reynolds

Dennis said:
Thanks Brendan,

That option for the 'Default database folder' was changed.

I am refering to the "Get External Data" default directory
Click to expand...


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?
 
B

Brendan Reynolds

Brendan Reynolds said:
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?
Click to expand...


Some further testing indicates that you may need to close and re-open Access
before the change sticks.
 
D

Dennis

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
 
B

Brendan Reynolds

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?
Click to expand...

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.
 

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

How do I change the default directory in MS Access? 4
Access 2007 Split Assets db, issue moving to new directory 0
How do I change the action of button in Access 2007 contact list? 1
Get Access to open in the last folder I used (not My Docs)? 2
Access Access 2007 "export" default destination folder 0
Graph data series formulas: How to global-change all sheet reference to formula 1
Changing the Forms & Reports Default Font in Access 2007 3
How do I get "Insert - Picture" to default to the local directory 3

Top