Getting Access filename only in 97

[MarkCapo]

Using Access XP you call the currentproject method and
pick up its name property to return the filename of the
current application file. I need to to a similar
function in 97 which only picks up the filename directly
rather than using a procedure that loops through the path
and filename to pick out filename from the
application.name result.

Can anybody help with this!

Thanks

mark

 

[Albert D. Kallal]

You can go:

Dim strFName As String

strFName = Dir(CurrentDb.Name)