ACC97: IPF in MSACCESS.EXE Saving Form to Different Name

• Microsoft Access 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

In Microsoft Access 97, when you open a form in the sample database Northwind.mdb and try to save it to a different name, you may receive the following error message.

Using Microsoft Windows NT 3.51 or 4.0

   MSACCESS.EXE
   Exception: access violation (0xc0000005), Address: 0x3007abf4

Using Microsoft Windows 95

   MSACCESS caused an invalid page fault in module MSACCESS.EXE at
   0137:3007abf4

RESOLUTION

Follow these steps to safely copy a form in the sample database Northwind.mdb to a different name:

1. Open the sample database, Northwind.mdb.

2. In the Database window, click the Forms tab.

3. Select the Orders form without opening it.

4. On the Edit menu, click Copy.

5. On the Edit menu, click Paste. In the Paste As dialog box, type "Orders Test" (without the quotation marks). Click OK. Note that the Orders form is safely copied to the new name, Orders Test.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Access 97. This problem no longer occurs in Microsoft Access 97 Service Release 1.

NOTE: Stand-alone Microsoft Access 97 Service Release 1 is not currently available, but you can update your copy of Microsoft Access 97 to Service Release 1 by downloading Microsoft Office Service Release 1 from Microsoft's Web site at:

   http://www.microsoft.com/office/office97/servicerelease

MORE INFORMATION

Steps to Reproduce Problem

WARNING: Following these steps will cause a general protection fault on your computer. Make sure you save and close any open work on your computer before following these steps.

1. Open the sample database Northwind.mdb.

2. Open the Orders form in form view.

3. On the File menu, click Save As/Export.

4. In the Save As dialog box, click "Within the Current Database as," and in the New Name box, type "Orders Test" (without the quotation marks). Click OK. Note that you receive the error message mentioned in the "Symptoms" section.

REFERENCES

For more information about saving database objects with different names, search the Help Index for "Copying Database Objects."