ACCESS form default value

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.

MS-ACCESS "System resource exceeded"

https://www.windowscentral.com/assign-specific-processor-cores-apps-windows-10

https://social.technet.microsoft.com/Forums/office/en-US/5828a030-f27f-4001-9aaa-8d2951ef4169/quotsystem-resource-exceededquot-for-simple-select-query-in-access-2013?forum=officeitpro

 

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.

MS-ACCESS: How to find a table in the relationship window

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.