ACC95: TransferText Method or Macro Action May Cause Error

MORE INFORMATION

The error occurs when you run Microsoft Access 7.0 with Microsoft Windows 95. It does not occur with Microsoft Windows NT Server 3.51 or Microsoft Windows NT Server 4.0.

Not all tables cause the error.

Steps to Reproduce Problem

Using the TransferText Action in a Macro:

1. Open the sample database Northwind.mdb.
2. Create the following new macro:
   

         Macro Name   Action
         -------------------------
         TestError    TransferText
   
   
         TestError Actions
         ----------------------------------
         TransferText
            Transfer Type: Export Delimited
            Table Name: Employees
            File Name: C:\Testerr.txt
            Has Field Names: No
   						

3. Save the macro, close it, and then run it.

Using the DoCmd.TransferText Method in a Procedure:

1. Create a module and type the following line in the Declarations section if it is not already there:
   

         Option Explicit
   						

2. Type the following procedure:
   

         Function TestError()
            DoCmd.TransferText acExportDelim, , "Employees", "C:\Testerr.txt"
         End Function
   						

3. To test this function, type the following line in the Debug window, and then press ENTER.
   
   ?TestError()