VBA code to identify location from where the database is opened

[AmanKaur123]

Hi All



I want to write a piece of code that will tell me location of the database when its opened.

I have created a database which users try to open from different locations so I basically need to know the location from where the database is opened.

Any help will be much appreciated.

Thanks

[CJ_London]

use

currentdb.name

to provide path and name