HI i have a .accdb file that is 51mb in size with two tables
table 1 has 27k records in it
i have the .accdb file set to compact upon closing.
When i open and close the file it seems to take longer than it should to compact (defrag) approx 10-13 seconds. this happens even if all i do is open and close the .accdb file (not touching any of the records)
Does this seem right? can it take this long to compact 27k records that haven't been touched since the last time they were compacted?
The reason i ask is my backend file (the one in question ) seems to be slowing the performance of the frontend applications attached to it and i think i have it narrowed down to this one particular table but am not sure.
thanks in advance