I have used two access database for years. on a DELL XPS 15 high RAM laptop for years (i think 8 GB or more) One application is a front/end back end parent-child relational design and the other a flat redundant design. they both have maybe 40,000 records. they both perform equally well.
I recently purchased a DELL flip screen 2-in-1 tablet/laptop 12.5 inch. 8 GB RAM The thing is lickety quick also on surfing and the split front end/backend design.
BUT THE REDUNDANT design is dog slow (sorry dogs) Anytime I click on anything (any combobox, a new record form icon, an input field,) the CPU goes to 29% and then DOES NOT RESPOND and soeteimes jumps to 93%
It lasts for 60 seconds to 3 minutes then settles down until the next click.
I tried deleting the database and recopying it from two different external drives . that didnt matter. I tried compacting again. that did not matter either
What could be going on? I can't function like that.