Know where current MDB file is

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff - 19 Oct 2005 02:54 GMT

Hello,

In Excel VBA, there is this command
ActiveWorkbook.Path
which can tell you the Path of where the active xls file that you working in
is.

Is there a similar command in Access VBA that can give you where the current
MDB file you are working with is in ? so you can know during runtime.

Thank you,
Jeff

Reply to this Message

Marshall Barton - 19 Oct 2005 04:04 GMT

>In Excel VBA, there is this command
>ActiveWorkbook.Path
[quoted text clipped - 3 lines]
>Is there a similar command in Access VBA that can give you where the current
>MDB file you are working with is in ? so you can know during runtime.

Depending on whether you want the file name part of the
path:
CurrentDb.Name
or not:
CurrentProject.Path

Signature

Marsh
MVP [MS Access]

Reply to this Message