JoshuaAnthony
Registered User.
- Local time
- Today, 08:00
- Joined
- Dec 18, 2003
- Messages
- 68
Database size issues (also queries vs filters)
Hi,
On one form of my database, I use around 50 different queries. These handle searches displayed in about 8 different text boxes on the same form depending on my search options. I was told that queries were better to use than filters because users can turn filters off (http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=60192). With no data in the database, it is around 8.58MB. When people put more data in, it seems to grow at an unusual rate. When there is around 50 entries, the database is around 25MB... Is this normal? Does it have anything to do with the fact that I am using queries? Does Microsoft Access copy (obviously not by reference!) the relevant parts of the main table into each query???
Could somebody let me know if this is normal and if there are any obvious ways I could decrease the size of my database please?
Thanks,
Joshua
Hi,
On one form of my database, I use around 50 different queries. These handle searches displayed in about 8 different text boxes on the same form depending on my search options. I was told that queries were better to use than filters because users can turn filters off (http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=60192). With no data in the database, it is around 8.58MB. When people put more data in, it seems to grow at an unusual rate. When there is around 50 entries, the database is around 25MB... Is this normal? Does it have anything to do with the fact that I am using queries? Does Microsoft Access copy (obviously not by reference!) the relevant parts of the main table into each query???
Could somebody let me know if this is normal and if there are any obvious ways I could decrease the size of my database please?
Thanks,
Joshua
