How Fix Microsoft Access Can’t Open The Form Or Report Error (2121)

Is your Access Database is denying to open up your saved form or report? Or getting Microsoft Access can’t open the form issue?

Well, if you too are a victim of this then try theses mentioned fixes to resolve this “can’t open form or report “error in Access.

Well many users like you rendering the same issue in their respective Access Database application.  Here is the scenario of one such user who is dealing with this “Microsoft Access can’t open the form it contains data that Microsoft Access doesn’t recognize” error.

Rated Excellent on Trustpilot
Free MS Access Database Repair Tool
Repair corrupt MDB and ACCDB database files and recover deleted database tables, queries, indexes and records easily. Try Now!
Download
By clicking the button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the End User License Agreement and Privacy Policy of this site.

Practical Scenario:

Hi..!

I was in the process of editing a complex form in Access 2013. At one point, when I closed the form (in design view) and tried to open it in form view, I got an error that access cannot complete the operation because there is not enough memory.

I know that the problem is not my computer, because I am able to open the database on another computer (with Access 2010), and when I try to open that form, or export it, or anything, I get the same memory error.

This form would take hours, if not days, to recreate.
Is there anything I can do? Thanks!

Source:

https://www.experts-exchange.com/questions/27584480/Access-form-won’t-open-Not-enough-memory.html

You might also be facing not exactly but similar kind of issue, so it’s important to know the fixes to resolve them as soon as possible. Take some important initiative before the completion of your data gets reached to a state from where the recovery is almost impossible.

So before stepping to the resolution for fixing” Can’t Open Form Or Report “error in Access. Let’s start with the little info on Microsoft Access fundamental objects i.e form and report.

Microsoft Access Fundamental Objects:

Forms:

The form is one such Access database objects that makes the data available on the screen.  With a form, you can view and edit the data like sorting, deleting, appending, and so on. The form actually lets you work with your data. It does’ store any data; it’s just a tool for viewing the data in your table. Any modification done in the form will reflect in the table.

Reports:

The other Access Database Object reports. Well this object, is to display your data but on paper. Unlike Form, Reports won’t allow you to edit the data as they are designed to static. Once you have printed your data on paper it’s going to be pretty static, so it means reports reflects that.

Microsoft Access Can’t Open The Form Or Report Error Details:

Error Code: Error 2121

Error Name: Microsoft Office Access can’t open the form ‘|

Software: Microsoft Access

Description:

Microsoft Office Access can’t open the form ‘|.’@It contains data that Microsoft Office Access doesn’t recognize. Re-create the form or, if you maintain backup copies of your database, retrieve a copy of the form.@@1@@@1.

Symptoms Of Access Database Error 2121?

When you make a form or report and apply a filter before saving it for the very first time and save it when the filter is still in effect, the filter can’t be turned off the form or report always display the filtered view of the underlying table or query.

What Causes Access Database Error 2121?

Though it’s, a new feature to easily create permanently filtered forms and reports. MS Access does this incorporating filter into the object’s design if the filter is working when the object is first saved.

Resolution To Fix Microsoft Access Can’t Open The Form Or Report Error -2121

If you don’t want a filter that you have used to a newly created form or report to be there permanently; then it’s better to remove the filter before you save the objects for the first time.

But if in case you have created the form or report and saved it for the first time while it is in a filtered state and later on you have decided that it shouldn’t be permanently there. Then also you can edit the object’s record source property by using the following mentioned procedure.

So let’s get started…!

Method 1: Access Repair N Recovery Tool

Well unable to open your Access Database form or reports is not just an issue it’s an indication that your MS Access form or report is somehow got corrupted. So, for such cases, if all manual solution fails to work then you must try the Access Repair N Recovery Tool as it is the most proficient solution to fix any corruption issue encountered in the Access Database.

* By clicking the Download button above and installing Stellar Repair for Access (14.8 MB), I acknowledge that I have read and agree to the End User License Agreement and Privacy Policy of this site.

Have a look at some of its quality features:

  • Effectively recovers tables, queries, forms, reports, macros, modules, relations, etc.
  • Easy restoration of all objects including deleted records to a new database
  • Easy retrieval of password-protected forms and modules.
  • Compatible with all versions of MS Access including the latest 2016.
  • Supports linked tables and calculated data types.

Steps To Use Access Repair N Recovery Tool

access-repair-main-screen
access-select-database
access-repairing
access-repairing-completed
access-preview
access-save-location
access-saving
previous arrow
next arrow

Method 2: Remove A Permanent Filter From A Form Or Report

  1. From the navigation panel, make a right-click over the form or report and then click the Design View present on the shortcut menu. The object will get open in Design View.
  2. If you are unable to see the property sheet then press F4 to display it.
  3. Tap to the object’s record source property box and then hit this The query designer appears with the object’s recordset query displayed.
  4. For the filtered fields and filter criteria, look in the query design grid.

In the shown figure, there is one filtered field CompanyName, and a single criterion, Contoso, Ltd.

Microsoft access can not open the form

  1. Make selections for the columns that contain a filtered field tapping to the gray bar present just above the Field row in the Query Design
  2. In order to remove the filtered field and its criterion, just press the DELETE option.
  3. Similarly, for each filtered field which you want to delete from the object’s design, repeat step 5 and 6.
  4. Close the query designer, as soon as you are prompted to save the change made to the SQL statement and update the property, click Yes.

By doing theses aforementioned steps you must have successfully removed the permanent filter from your form or report.

Method 3: Import The Other Objects Into A New Database

While creating a form, reports, and the code in their modules, there are many chances for them to get corrupt. To work around this, import other objects into a new database.

This process attempts to create a new file and import the data from the corrupted database. To do this follow done these steps:

  • Start Microsoft Access.
  • Select for a Blank Access Database and click OK.
  • Assign a new name to your database and choose a file location, after then click to Create.
  • Now click on the File menu, go to Get External Data, and select Import.

Import-Access-Database-1

  • To import the Access database tap to the Access option.

  •  You will see a get external data Access Database window is get opened on your screen.

  • If in case you don’t receive any import object window than this process can’t recover your Access database otherwise, continue.
  • Click to the Tables tab at the top of the Import Object Window and click Select All.Import-Access-Database-9
  • Do the same thing for the other 6 tabs also in the window. At last click the OK button when done.

After completing all these, the data from the corrupted database should now be in the files that you have just created.

Conclusion:

Removing the permanent filter from any form or report doesn’t preclude you from using the same filter in a form fashion on this object in the future. It only deletes it from the object’s design so that you can view all the records in its underlying table or query by default.

Now you can flawlessly work with your Access Database Form And Reports. If you find this post helpful then share your opinion in our comment section. You can also discuss if you are been facing any other issue too.

tip Still having issues? Fix them with this Access repair tool:

This software repairs & restores all ACCDB/MDB objects including tables, reports, queries, records, forms, and indexes along with modules, macros, and other stuffs effectively.

  1. Download Stellar Repair for Access rated Great on Cnet (download starts on this page).
  2. Click Browse and Search option to locate corrupt Access database.
  3. Click Repair button to repair & preview the database objects.

Pearson Willey is a website content writer and long-form content planner. Besides this, he is also an avid reader. Thus he knows very well how to write an engaging content for readers. Writing is like a growing edge for him. He loves exploring his knowledge on MS Access & sharing tech blogs.