[AccessD] increasing database size

Pedro:

Before going any further I would remove all of the row sources from the
combo boxes and load the form.  If it loads real fast then the slowdown is
in the combo boxes.  If not it's somewhere else so you won't have to go
through a lot of gyrations with them for no good purpose.

If it is the combo boxes then you can use Colby's (I think?) trick of
loading the row source of the combo box the first time it is clicked.  In
the GotFocus event of the combo box if there's no row source, then you load
it at that point.

You can store the Row Source in the Tag and then:

Private Sub cboBuilding_GotFocus()
    If cboBuilding.RowSource = "" Then
        cboBuilding.RowSource = cboBuilding.Tag
        cboBuilding.Requery
    End If
End Sub

HTH

Rocky


----- Original Message ----- 
From: "Pedro Janssen" <pedro at plex.nl>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Saturday, February 14, 2004 1:01 PM
Subject: Re: [AccessD] increasing database size


> Hello Gustav and Rocky,
>
> all of the databases that i have designed at work or at home don't have
> backend and frontend. A maximum of 6 users are working with them. In this
> group i heard a lot about front- and backend. Could you give me the
> advantage and disadvantage of this method.
>
> The form indeed loads about 12 comboboxes with each 1500 records. Further
it
> has about 150 textboxes where the control source is one of the columns of
> these comboboxes.
>
> Anyway could i speed up things and is this the problem for the increasing
> database.
>
> Pedro Janssen
>
>
>
>
> ----- Original Message -----
> From: "Rocky Smolin - Beach Access Software" <bchacc at san.rr.com>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Saturday, February 14, 2004 2:46 PM
> Subject: Re: [AccessD] increasing database size
>
>
> > Pedro:
> >
> > Does your form have sub-forms?  Does it have a tab form?  Does it have
> combo
> > boxes with large numbers of records to load?
> >
> > Rocky
> >
> > ----- Original Message -----
> > From: "Gustav Brock" <gustav at cactus.dk>
> > To: "Access Developers discussion and problem solving"
> > <accessd at databaseadvisors.com>
> > Sent: Saturday, February 14, 2004 5:15 AM
> > Subject: Re: [AccessD] increasing database size
> >
> >
> > > Hi Pedro
> > >
> > > If your frontend is not supposed to write data to itself, you may
write
> > > protect the file when you have finished design changes and compacting.
> > >
> > > /gustav
> > >
> > > > how is it possible that a database increases its size by 1/3 when
> > opening a complex form?
> > >
> > > > Opening this form in formview or designview also costs (pentium4
> 2600Mhz
> > 256MB-ram) about 25 sec.
> > > > How is this possible and can i decrease the time?
> > >
> > > _______________________________________________
> > > AccessD mailing list
> > > AccessD at databaseadvisors.com
> > > http://databaseadvisors.com/mailman/listinfo/accessd
> > > Website: http://www.databaseadvisors.com
> > >
> >
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>