Access 2007 Default Export Path

[NickH1]

In earlier versions the default path for exporting to Excel was the database path. This is not the case now and Access defaults to the users Documents folder. Of course in the world of business this is never where you want to export to.

Is it possible to set the default export path. I see no other paths in the registry.

 

[James Dudden]

Hi,
The best way is to set a database property and refer to this in your code.
Regards
JD

 

[NickH1]

Hi,
The best way is to set a database property and refer to this in your code.
Regards
JD

Unfortunately, in this case, I am not talking about code I am talking about plain manual exporting.

I may yet have to resort to writing a macro which calls a bit of code. And I thought Access 2007 was all about making the user interface easier for none-code-writing users.

Please excuse me. For us, here in the backwaters, Access 2007 is a 'new' product and so I am still getting over the lack of progress since Access 2000.

 

[James Dudden]

HI,
I'm working in A2003 so can't really help with A2007 I'm afraid.