How to get mdb path and filename in VBA

Topic

New Reply

I’ve done several quick searches on this but have come up empty, so far.

How do I get the current mdb path and filename in VBA? I want to display that info on several forms.

Example: If the file I’ve opened is abc.mdb, I would like to display that name (and full path) on several forms.

Thanks in advance.

Reply | Quote

Replies

You can use

CurrentDb.Name

or

CurrentProject.FullName

Both return the full path and filename of the active database.

Reply | Quote

Thanks, Hans.

The currentproject.fullname works perfectly.

Reply | Quote