R
Robbo
DoCmd.TransferDatabase acExport, "dBase III", CurrentDb.Name, acTable,
"tblTempOutput", "C:\Out.dbf"
Can anyone tell me if there is something wrong with the above code because
at this stage I am thinking I will need to reload MS Access. When I run it
from a Sub in a module I get a message to say that says:
"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 try to create the database using the MS Access menu paths it works fine.
I have tried changing CurrentDb.Name in the code with the fully qualified
name and the same thing happens.
I tried changing the formal from "DBase III" to "Microsoft Access" and,
whether I use the output path of "C:\Out.dbf" or "C:\Out.mdb" or
"C:\Out.accdb" it tells me that the output doesn't comply with Microsoft
naming conventions.
I have also checked that the name I am using ("tblTempOutput") is correctly
spelled (I copy and pasted the name to make sure)
"tblTempOutput", "C:\Out.dbf"
Can anyone tell me if there is something wrong with the above code because
at this stage I am thinking I will need to reload MS Access. When I run it
from a Sub in a module I get a message to say that says:
"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 try to create the database using the MS Access menu paths it works fine.
I have tried changing CurrentDb.Name in the code with the fully qualified
name and the same thing happens.
I tried changing the formal from "DBase III" to "Microsoft Access" and,
whether I use the output path of "C:\Out.dbf" or "C:\Out.mdb" or
"C:\Out.accdb" it tells me that the output doesn't comply with Microsoft
naming conventions.
I have also checked that the name I am using ("tblTempOutput") is correctly
spelled (I copy and pasted the name to make sure)