If you are getting a 'not valid file name error' then it is likely that a file with that name doesn't exist.

There is a difference between cstrPath and strPath - are you sure you are using the right variable when you open the connEmp? It looks like you intended to build the full path by getting the current path and appending the constant to point inside a folder BUT your code is not quite doing that.

Add the following lines before the connEmp.Open line to check the value of cstrPath and strPath

Debug.Print cstrPath
Debug.Print strPath

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia