Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I determine my db name? 1

Status
Not open for further replies.

OhioSteve

MIS
Mar 12, 2002
1,352
US
In my vba code I use my application's address repeatedly. Unfortunately, when I move it or make it an .mde that code fails. I have MOSTLY fixed this problem. Now my application has a global variable for the address. So when I change the application's location, I just change that value.

My question is, can I TOTALLY eliminate this problem? Can I call a method that returns the path of the current db? I looked at all of the Environ() collection, and I did not find anything.
 
Some notes:
[tt]CurrentProject.FullName - Full name and path
CurrentProject.Path - Path only[/tt]

 

Just to add the difference between those or Remou

CurrentProject.FullName - CurrentProject.Path =
CurrentProject.Name

Which is just the name
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top