[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
>