TransferDatabase problem

  • Thread starter Thread starter Ron Carr
  • Start date Start date
R

Ron Carr

I am attempting to use TransferDatabase to create a .dbf file that goes into
another application.
The 3rd parameter is causing me problems.
Help says"A string expression that's the full name, including the path, of
the database you want to use to import, export, or link data."
That's what I have, but I am told this is an invalid path.
DellInputData is data-only back end.
I have tried this with the front end DB also no joy.
IOptions.dbf is the output table I would like to create.

DoCmd.TransferDatabase acExport, "dBase 5.0",
"C:\Users\Ron\Access\LymeComputerSystems\DellInputData.mdb", acTable,
"DellOutput", "C:\Users\Ron\Access\LymeComputerSystems\IOptions.dbf"

Message:
'"C:\Users\Ron\Access\LymeComputerSystems\DellInputData.mdb" is not a valid
path'

Any ideas please?
Ron
 
Not sure of this, but it may be because the name of your .mdb database file
is more than 8 characters (without the extension). .dbf enforces 8+3 naming,
so it's possible that the ACCESS database also must meet this criterion. Try
shortening the name of the database, or use the 8+3 name that Windows
assigns for the file.
 
Not sure of this, but it may be because the name of your .mdb database file
is more than 8 characters (without the extension). .dbf enforces 8+3 naming,
so it's possible that the ACCESS database also must meet this criterion. Try
shortening the name of the database, or use the 8+3 name that Windows
assigns for the file.
 
Try moving the .mdb file to a higher folder in the hierarchy. Might be a
character limit for the length of the path and filename.
 
Try moving the .mdb file to a higher folder in the hierarchy. Might be a
character limit for the length of the path and filename.
 
Back
Top