How to view path information from tool bar

[RenaG]

Using Access 2007.

Is there a way to set up Access so that it shows in the tool bar the path of the db that is open (or somewhere on the window)? If not, any tips on how to do a visual verification on what db you have open? I am concerned that I will accidently modify the production db when I need to be in the development db.

TIA,
~RLG

 

[John Big Booty]

=Application.CurrentProject.path

Will return the path of your DB.

 

[RenaG]

Thanks for that info. I wasn't sure where to put it but tried it in the Immediate window replacing the '=' with '?'. And that returned the path information. What I was hoping to find was a way to display that information in the title bar in the app itself. Where would I put the command you sent?

TIA,
~RLG

 

[RenaG]

I just discovered this, which will work:

In the Access Options window | Current Database, Application Title:

I can put 'Production' as part of the title and it will display on the title bar. I just have to remember to change it when I move the development fe to the production fe .

~RLG