Docmd.TransferDatabase acExport file name problem

  • Thread starter Thread starter Sunny
  • Start date Start date
S

Sunny

Windows XP SP2
Access 2007

I am trying to export query results to dbase 5.0 format. It exports fine but
somehoe it truncates the file name to 8 charaters. It used to work fine but
since I changed the computer I am having this probleb. Can anyone please
help me?
Here is my syntax:

DoCmd.Transferdatabase acExport, "dBase 5.0", CurrentProject.Path, acTable,
"myTable", "LongDBFFileName.dbf"

It creates the export and save as LongDBFF.DBF
 
But it used to work fine for 5 years and still working ok on old m/c with
windows xp and access 2007. We got new m/c last month and since then we are
having problem. I am thinking this has to do something with odbc drive came
with the m/c., but I dont know how to check and what to check?
 
im SPER TO IN LONDO WE DO IN AT ON TIME ON AT BASICES IN AT COLLICE AND TICE
IN AT SOMONE WE RAE IN TO DE IN THURROCK WE AT SOMSON IN NICOLAS JAMES BEGGS
109 MOLLAND LINE SUTH OCKOND IN ESSEX
 
Sunny said:
Windows XP SP2
Access 2007

I am trying to export query results to dbase 5.0 format. It exports fine
but somehoe it truncates the file name to 8 charaters. It used to work
fine but since I changed the computer I am having this probleb. Can anyone
please help me?
Here is my syntax:

DoCmd.Transferdatabase acExport, "dBase 5.0", CurrentProject.Path,
acTable, "myTable", "LongDBFFileName.dbf"

It creates the export and save as LongDBFF.DBF
Click to expand...
 
Back
Top