Can anyone tell me what is wrong with the following code. When I run it from I get a message to say that
"C:\Documents and Settings\Rob\My Documents\MyDatabase.accdb is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides." If I run it manually it works fine.
DoCmd.TransferDatabase acExport, "dBase III" _
, CurrentDb.Name, _
"C:\Documents and Settings\Rob\My Documents\Out.dbf"