ACC2000: Errors Converting or Importing with 754 or More Controls

ID: Q208192

The information in this article applies to:

Microsoft Access 2000

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

SYMPTOMS

When you convert or open a database created with an earlier version of Microsoft Access, you may receive one or more of the following error messages.

The form or report <form name> has too many controls.
Reduce the number of controls on the form or report before using it in this version of Microsoft Access.

-or-

Microsoft Access Failed to create the Visual Basic Module 'Form_<form name>.'
If your Database is on a network drive, check your network connection, and then try again.

-or-

Microsoft Access Failed to convert or enable your code modules.
Your computer may be low on disk space or memory.

Also, if you try to import a form or report from a database created with an earlier version of Access, it is not imported and you receive no errors.

CAUSE

There is at least one form or report in your database that contains a Visual Basic for Applications module and it has 754 or more combined controls, sections, and fields in the RecordSource property.

RESOLUTION

Use the version of Microsoft Access with which you originally created the database to modify the design of the form or report. Reduce the total number of sections, controls, and fields in the RecordSource property to fewer than 754.

If the record source for the form or report contains a large number of fields that you do not need to display, consider creating a query that only selects the fields that you need to display, and set it as the RecordSource property for the object.

MORE INFORMATION

Access 2000 limits the total number of controls, sections, and fields in the RecordSource property to 754. For example, if a form contains a detail section, 500 unbound text boxes, a Visual Basic for Applications module, and a record source that contains 255 fields, you receive the errors listed in the "Symptoms" section when you convert or open the database. This occurs even though none of the fields in the RecordSource property are actually used on the form.


                  Number of Controls: 500
                  Number of Sections:   1
    Number of Fields in RecordSource: 255
                                      ---
                                      756

If a form or report does not contain a Visual Basic for Applications module but does exceed the 754 control limit, the conversion may succeed, but you may receive other errors when you try to design or use the form in the newer version.

REFERENCES

For more information about limitations and design specifications, click Microsoft Access Help on the Help menu, type "specifications" in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

For more information about converting databases, click Microsoft Access Help on the Help menu, type "converting databases" in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words:

Keywords : kberrmsg kbdta CnvErrs
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb