This may be a long shot, but is there any workaround to the issue where Access crashes if you try to open a table in design view when you are in a Numeric field?
I have tested this in completely blank databases and I can easily reproduce this bug in any table.
Long story short, if my first field in a given table is numeric and I try to open the table in design view, the database crashes. If the first field is a string, I can open the table in design view and make changes, but if I click on any numeric field while in design view, the database instantly crashes.
From what I found online, this has been an issue since the 2016 version was released, which is the version I use. Does not seem like it was ever corrected by Microsoft, at least in this version, and it has to do with your field size or something.
Just wanted to know if anyone has found a way around this and if there is any way I can change the properties of a numeric field in design view.