How Retrieve Curr .mdb file location

  • Thread starter Thread starter Ross
  • Start date Start date
R

Ross

How can I programatically retrieve the current database
file location string?

ie
I want to export a query to the current location of the
database.
 
CurrentDb.Name
How can I programatically retrieve the current database
file location string?

ie
I want to export a query to the current location of the
database.
Click to expand...
 
CurrentProject.Path will tell you the path of the current database (assuming
A2000 or greater) ... I believe Currentdb.path is available for A97, but
can't be sure.
 
Scott

Perfect! Thanks

Ross


-----Original Message-----
CurrentProject.Path will tell you the path of the current database (assuming
A2000 or greater) ... I believe Currentdb.path is available for A97, but
can't be sure.

--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP



.
Click to expand...
 
Back
Top