Hi I am using the following to get my file locations

Set wShell = CreateObject("WScript.Shell")
path = wShell.SpecialFolders("Desktop")
path2 = "E:/Backup"

I need to change path 2 to be the same location as the
mdb file almost like a root.

Is this possible?

Thanks

Rob