AlanBates

I am trying to run code which will return the path name of the file that is being opened. e.g. I have an Access Database which could have be copied into a different folder from where I want it to stay. I would like it to check where it is as it opens. Does that make sense?

karimahta

<font color=blue>CurrentDB.Name</font color=blue> is the property you are after. This includes the full path and file name of the database.


HTH

<font color=blue>Better to remain a fool than write a quote and remove all doubt. (****!!)</font color=blue>

AlanBates

Thankyou, it works fine.