TransferDatabase problem

[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

 

[Ken Snell MVP]

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.

 

[Ken Snell MVP]

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.

 

[Ron Carr]

Tried it out as C:\D-Data.mdb.
No joy.
Worth the try tho!
Ron

 

[Ron Carr]

Tried it out as C:\D-Data.mdb.
No joy.
Worth the try tho!
Ron

 

[Ken Snell MVP]

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.

 

[Ken Snell MVP]

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.