[AccessD] TransferText Causing System Crash

Oh and one other thing to check that you have installed
Overview of Office XP Service Pack 3 for Access 2002 Runtime. Note this 
is in addition to normal SP3
http://support.microsoft.com/default.aspx?scid=kb;en-us;834693&Product=acc

MartyConnelly wrote:

> Well it looks like different Office XP service packs on the machines, 
> XP SP-3 on your development machine.
> Are you doing a full new runtime install on the server, or just 
> passing over the adp file to the server with changes.?
> This could lead to problems.
>
> David Emerson wrote:
>
>> Group,
>>
>> I have an AXP ade/SQL2000 runtime setup running on Windows 2003 
>> Server.  When I use the DoCmd.TransferSpreadsheet or 
>> DoCmd.TransferText commands my database crashes (Unexpected error in 
>> MSAccess.exe).
>>
>> Examples are -
>>
>> DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel7, 
>> strTableName, strFullName
>> DoCmd.TransferSpreadsheet acImport, , "dbo.ttmpTOURawData", 
>> strFullName, False
>> DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, 
>> "dbo.ttmpSwitchNewIn", Me!txtSwitchFile, True
>> DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, 
>> "dbo.ttmpTemporary", Me!txtDataFile
>> DoCmd.TransferText acExportDelim, , "dbo.ttmpAgedDebtorDDebitExp", 
>> strFullName
>> DoCmd.TransferText acExportDelim, , "dbo.ttmpExportMerge", 
>> DLookup("RootFolder", "tblCompany") & "\Merge\CustMerge.TXT", True
>> DoCmd.TransferText acExportDelim, , "dbo.ttmpSwitchNewOut", 
>> DLookup("RootFolder", "tblCompany") & "\Switch\CustSwitch.TXT", True
>> DoCmd.TransferText acImportDelim, , "dbo.ttmpTOURawData", 
>> strFullName, False
>>
>> The commands work on my development machine (WXP Professional with 
>> Office 97 and Office XP).
>>
>> I have tried uninstalling and reinstalling the runtime application.
>>
>> Other commands in the Access library seem to work ok.  The version of 
>> the olb (C:\Program Files\Microsoft OfficeXP\Office10\msacc.olb) on 
>> my machine is 10.0.6308.0.  The runtime machine (C:\Program 
>> Files\Microsoft Access Runtime\Office10\msacc.olb) has version 
>> 10.0.2627.1.
>>
>> Any clues why the transfer commands might be causing problems?
>>
>>
>> Regards
>>
>> David Emerson
>> Dalyn Software Ltd
>> 25 Cunliffe St, Churton Park
>> Wellington, New Zealand
>> Ph/Fax (04) 478-7456
>> Mobile 027-280-9348
>
>
>

-- 
Marty Connelly
Victoria, B.C.
Canada