A question has surfaced a few times in Access forums regarding how one could display the Path/Name, or both, in the Access Application Title Bar. I previously contributed my two cents worth to the following thread:

http://answers.microsoft.com/en-us/office/forum/office_2007-access/how-to-show-the-path-of-the-access-file-on-the/15065cb1-1e71-e011-8dfc-68b599b31bf5

that said, I decided to put together a simple concrete example to dissect and learn from.  So feel free to download the following Access 2007 accdb sample (although the code will work in prior and future versions as well).

Display The Current Database Path In The Access Application Title Bar

Basically, all the code is contained within a single standard module and executed by the AutoExec macro upon launching your database.