First, you need a backslash before the source location.Second, FileCopy is going to want the name of the file. In other words, if we weren't using a variable, the copy would look likeVB Code:
FileCopy app.Path & "\FinancialData.mdb", strDBLocationDoes strDBLocation contain the new folder path AND the db name?VB Code:
FileCopy "c:\folder\FinancialData.mdb", "c:\otherfolder\FinancialData.mdb"




Reply With Quote