I have frontends that grow in size over time. the largest one right now is 65MB which isn't awful for the amount of time.
I read that front ends grow in size from executing queries and accumulating temporary data.
I know you can clear it out using compact and repair but I am wondering if there are good practices/bad practices and things I can seek out to optimize it or even eliminated it?
Side note: I inherited these front ends and they are all different sizes. Upon compacting and repairing some are still varying sizes but afaik they are identical.
The backend for all these frontends is an Access DB. In a separate unrelated DB I used passthrough queries and it doesn't seem to increase in size at all so I guess that is one technique? It makes me wonder if the temporary storage grows on the SQL server end though...