I have a DB full of customer complaints. My backend is SQL and I use Access as a front end. Each complaint is a record in my tblComplaints table. This table probably has 50 to 60 fields for each record.
I then have a form that looks at each complaint individually and allows the user to use 'next' and 'previous' to switch complaints.
When changing records in the form, the 'loading' cursor pops up for a second or two which is kind of annoying. I think because there's a lot of fields for each record and the form isn't filtered down at all. It's control source is the main table.
I am wondering if it would be advantageous to reconstruct my DB and split the main table into six or seven tables.
Ultimately, all that data will still need to be fields in this form so I'm mainly wondering if I should expect significant speed differences.
I know theoretically it should be organized better (I inherited this DB) but I want to ensure there will be some speed benefits too before embarking.