The default folder is:
CurDir
The folder where the mdb file resides can be parsed from:
dbEngine(0)(0).Name
The location of the data file for an attached table can be parsed from:
dbEngine(0)(0).TableDefs("MyAttachedTable").Connec t
To programmatically check the location of attached tables when the
application starts, and and pop up a File Open dialog for the user to locate
where they have moved to, see solutions.mdb. This file is an optional sample
database that can be installed with Access 97. For later versions, you can
download the file from:
http://msdn.microsoft.com/library/of...dbdownload.htm
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
"wolftor" <wo*****@rogers.com> wrote in message
news:jQ*********************@news01.bloor.is.net.c able.rogers.com...
I want to change the default folder but can't seem to see where this is
done.