There was a default value of 1 in the form cell even when I have not yet entered the data. I looked at the table and the relevant column. The default value of 1 was in the property. I changed that to "" and the unnecessary 0 in the form cell disappeared.
So in my case (Windows 10):
1) Control-alt-calc and choose Task manager
2) Go to Details tab and right-click on MSACCESS.EXE
3) Choose SET AFFINITY
I think this will let the computer to use most energy/memory/effort only on that software.
I have not tested this yet.
An error message saying "there is not enough memory."
OPTIONS (You will get a small window Access Options)
General (left, top)
Disable hardware graphics acceleration -- to CLICK ON
The following did not work well. When I find a solution, I will update this post.
When I removed a column from a table, ACCESS gave me a message saying I first needed to remove the link(s) from the relationship window.
This means that a column I wanted to delete had an existing relationship (or relationshipS) with another table(s). The following is the summary of what I did.
I have to break these link(s) first. The problem is when there are a lot of tables in the relationship window, relevant tables and links between them are hard to locate.
I suspect in some cases some tables are hidden for an unknown reason.
Pull the table away from other tables, so you can clearly see the links themselves. Click each one of them to see with which table the table is linked. You will eventually find the table you are looking for. Remove the links to break the relationships. Then you can delete the columns you want to delete.
Up to this point, I thought the problem was solved, but I keep getting the message, "Enter Parameter Value." "Birth month" as it appears in the message graphic is one of the two variables/columns I deleted. I got stuck.
I found this video, which may or may not be relevant to solve my problem.
This creates a library in which you will find all tables in the Access database.
libname johnwayne pcfiles path="C:\temp\this_is_access_data.accdb";
You will find a library (johnwayne in this example) in the SAS-Explorer window.
And I did something and it showed inactive forms.
I highlighted them all and unhide.