Microsoft KB Archive/101080

From BetaArchive Wiki

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

Q101080



The information in this article applies to:


  • 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.


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:




  1. Select the Employees table in the Database window.
  2. From the Edit menu, choose Copy.
  3. From the Edit menu, choose Paste. Type the new table name in the Paste Table As dialog box, and then choose OK.

From the File menu, choose Export.




Select Text (Delimited) as the Data Destination.




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




The following error message appears:


Microsoft Access
Out of Memory

Additional query words: import paradox excel fixed

Keywords : kb3rdparty
Issue type : kbprb
Technology :


Last Reviewed: November 4, 2000
© 2001 Microsoft Corporation. All rights reserved. Terms of Use.