ACC2000: Can't Save Large VBA Project in Windows NT 4.0 (218993)



The information in this article applies to:

  • Microsoft Access 2000, when used with:
    • the operating system: Microsoft Windows NT 4.0

This article was previously published under Q218993
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

When you try to save your database's Visual Basic for Applications project in Microsoft Access 2000 running on Windows NT 4.0, you may receive the following error message:
The Save Operation Failed.
This may be followed with the error:
Microsoft Access could not save your project.

CAUSE

You have Windows NT 4.0 Service Pack 3 (SP3) installed. If your database's Visual Basic for Applications project is several megabytes in size, you may not be able to save it in Windows NT 4.0 Service Pack 3.

RESOLUTION

Upgrade to Windows NT 4.0 Service Pack 4 (SP4).

For additional information about Windows NT 4.0 Service Pack 4 (SP4), please see the following Microsoft Web site:

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

The Microsoft Visual Basic Environment (VBE) uses OLE storages to read and write Visual Basic for Applications projects. In Windows NT 4.0 SP3, a low memory condition could occur when reading and writing to a large OLE storage. In Windows NT 4 SP4 this behavior is corrected.

Modification Type:MajorLast Reviewed:7/20/2006
Keywords:kbbug kberrmsg kbnofix kbprogramming KB218993