ACC1x: "Out of Memory" Error Message When Exporting Table

• Microsoft Access versions 1.0, 1.1

SYMPTOMS

When you are exporting a Microsoft Access table, an "Out of Memory" error message occurs.

CAUSE

This error message can occur if you have included a nonalphanumeric character in your table name. Examples of nonalphanumeric characters include the colon (:) and the comma (,).

RESOLUTION

Rename the table, making sure not to include any nonalphanumeric characters in the table name.

STATUS

This problem no longer occurs in Microsoft Access version 2.0.

MORE INFORMATION

If the export table name you create in the File Name box of the Export to File dialog box contains any non-alphanumeric characters, Microsoft Access tries to create a filename with these characters and causes an MS-DOS error. This error occurs when you are exporting to any data destination that creates an MS-DOS filename for the table.

Steps to Reproduce Behavior

NOTE: Changing the data destination in step 3 below to something other than Text (Delimited) may cause the error message not to occur.

1. Copy the Employees table in the sample database NWIND.MDB to a table named Empl,Nwind (note the comma in the table name). The steps to copy a table are as follows:

       a. Select the Employees table in the Database window.
   

       b. From the Edit menu, choose Copy.
   

       c. From the Edit menu, choose Paste. Type the new table name
          in the Paste Table As dialog box, and then choose OK.
   

2. From the File menu, choose Export.

3. Select Text (Delimited) as the Data Destination.

4. In the Select Microsoft Access Object dialog box, select the Empl,Nwind table and then choose OK.

      Microsoft Access
      Out of Memory