Need setup for Application.CurrentProject.Path

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want an export query to look for "ExportData.mdb" in the same folder as "Source.mdb"
I'd like to us
Application.CurrentProject.Path & "\ExportData.mdb

It doesn't work as the contents of the "Destination DB" query property
How do I set it up correctly
Do I need to use it in visual Basic to get a string path
 
I just played with this a little. It appears that the old Dos short hand for
"current directory" will work.

".\ExportData.mdb"

Note the dot before the backslash.
 
Back
Top