Docmd.TransferDatabase acExport file name problem

[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

 

[Alex Dybenko]

Hi,
yes, this is a limitation of dbase isam driver, but you can first export to
a short name and then rename the file using Name statement

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Sunny]

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?

 

[Alex Dybenko]

Hi,
Hmm, I don't know, but since access 97 till 2007 I never managed to export
to long name DBF. I used only dbase III format, this could be a reason, but
on other hand - ISAM driver is the same for all DBF formats. Try to compare
ISAM driver (Msxbde40.dll) versions
Look here also http://support.microsoft.com/default.aspx/kb/230125

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[NICOLHOLAS JAMES BEGGS]

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

 

[Oliver Twinberrow]

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