Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/255666

From BetaArchive Wiki

ACC2000: Save Record Command Is Not Available When You Set AllowEdits Property to No


The information in this article applies to:

  • Microsoft Access 2000

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

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


The Save Record command on the Records menu is not available (it is dimmed). You cannot use the command to save a new record.


Microsoft Access 2000 does not check the setting of the AllowAdditions property of the form. Access just checks the underlying state of the AllowEdits property. If the AllowEdits property is set to No, the Save Record command is not available.


To work around this behavior, move to a new or to an existing record. This will save the new record. To move to a new or to an existing record, use the record navigation buttons. You can also point to Go To' on the Edit menu, and click one of the following commands: '



New Record


Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


In earlier versions of Microsoft Access, when you set AllowEdits property to No and the AllowAdditions property to Yes, you can still enter a new record, and then save the record by using the Save Record command. In Access 2000, however, you cannot do this.

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.
  2. In the Database window, click Forms, right-click the Customers form, and then click Design View.
  3. On the View menu, click Properties.
  4. Click the Data tab, and then set the AllowEdits property to No.
  5. On the View menu, click Form View.
  6. On the Edit menu, point to Go To, and then click New Record.
  7. In the new record, type the following data:
  8. Click the Records menu. Note that the Save Record command is not available.

NOTE: Because the Save Record command is not available, code that tries to save the record is not successful. For example:

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 


DoCmd.RunCommand acCmdSaveRecord 

If you run this code, you will receive the following error message:

The command or action 'SaveRecord' isn't available now.


For more information about the AllowEdits or AllowAdditions properties, place your mouse pointer on one of the property names, and then press F1.

Additional query words: pra grayed greyed out gray grey can't use won't work doesn't

Keywords : kbdta
Issue type : kbbug
Technology : kbAccessSearch

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