A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Queries in forms causing database to bloat in size (kb)



 
 
Thread Tools Display Modes
  #1  
Old October 19th, 2009, 12:50 PM posted to microsoft.public.access.forms
Doug
external usenet poster
 
Posts: 616
Default Queries in forms causing database to bloat in size (kb)

Hi,

I've created a form that has 3 combo boxes on it and a graph.

The data source for each of the combo boxes is a query. Depending on what's
selected in the first one the possible results of the 2nd & 3rd are affected
because they use the subsequent selection value as a filter as a part of the
query. The graph that's generated is then shown as a result of each of the 3
options & so in turn, queries the query based on the 3 options as filters in
it's where clause...

The query isn't massive, runs quickly and the form's pretty quick to work
with. However, I get a serious problem with it increasing the size of my db
from 2.5mb to 22mb after using the form just a few times!!

Obviously, I can compact the database & get it back down to lower levels -
but I don't understand / know if there's anything I can do to stop this
massive (for me) build up in the size of my database (Access 2000).


Any help much appreciated.
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:54 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.