What variable holds the name and path of my db?

[M Skabialka]

What is the variable I can use to find out the name and path of the database
that is currently open? e.g.

"C:\user\mydb.mdb"

Currently users are supposed to make a copy of the master database from the
server, and put it on their own PCs in a C:\User folder. I noticed
yesterday that someone had the master copy open, which leaves it amenable to
corruption, plus it's as slow as death for the user.

I'd like to be able to check the path as soon as it is opened, and if it
isn't the local copy, pop up a warning message, then close the database.

Thanks,
Mich

 

[Allen Browne]

CurrentDb().Name