Default database folder

[Michael J. Strickland]

Is there a way to get Access to use the current database's folder
as the default database folder for file manipulations (e.g exports, imports, etc.)?

I want my datasheet exports to go to the same folder as their database so I know where to find them.

If you clear the "Default database folder" setting, it resets itself to "C:/My Documents".

If you want to use "C:/My Documents", you can set it explicitly (and it can even be the installation default). However, if you clear this setting, Access should use the current database folder.

Btw, I know how to do this in VBA code. What I'm looking for is a way to do it without code.

--

 

[Guest]

Have you tried actually inputting the path you want the default folder to be?
In other words instead of clearing the field (and thus allowing it to reset
to the windows default), populate it with the path you want and see if that
works. Hope this helps.