[AccessD] TransferText Causing System Crash

Thanks Marty,  Will test that out on Monday.

David

At 27/08/2004, you wrote:
>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
>
>
>
>--
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>