[AccessD] increasing database size

Very good.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins
Sent: Saturday, February 14, 2004 2:29 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] increasing database size


http://techrepublic.com.com/5100-6329-5031812-1-1.html?tag=search

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Pedro Janssen
Sent: Saturday, February 14, 2004 4:01 PM
To: Access Developers discussion and problem solving
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

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com