Try using something like
Code:
App.Path & "\" & "Westfield.mdb", "C:\WestfieldInsurance\old_Westfield" & format(now, "mmddyyyy") & ".mdb"