Q: default open folder?

[MarkD]

Using Access 2000.

Hi,

Right now, the default folder for table imports is My
Documents. Our databases here are usually project specific
and each project is in a separate folder. Is there a way
to change the default to the same folder where the
database resides?

So, if the database is in
R:\folder\subfolder\databasename.mdb, when I import a
file, the default starting path is R:\folder\subfolder\

Thanks!
-Mark

 

[Douglas J. Steele]

I assume you're starting your application by double-clicking on the MDB (or
by starting Access and selecting the application from the MRU--Most Recently
Used--list). The only way I can think of would be to run code on StartUp
that uses CD (aka ChDir) to change the current directory.

If you're using shortcuts to open the database, you can set the path in the
shortcut.

If you're opening the application by starting Access and navigating to the
database, that will set the directory appropriately.

 

[MarkD]

Thanks Doug,

Yeah, I'm opening the mdb directly or using the MRU. Good
idea with creating the code and running an autoexec macro
to change the folder.

-Mark