ACCESS – My Statistical tools

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.

October 10, 2019October 10, 2019

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.

October 9, 2019October 10, 2019

MS-ACCESS, not enough memory

An error message saying "there is not enough memory."

https://social.technet.microsoft.com/Forums/en-US/d1f61f7c-5eb2-4c1b-9bd2-85a65ab05344/excel-there-isnt-enough-memory-to-complete-this-action?forum=officeitpro

OPTIONS (You will get a small window Access Options)

General (left, top)

Disable hardware graphics acceleration -- to CLICK ON

November 16, 2018November 16, 2018

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.