[AccessD] Linking speeds

Hi Andy:

Thanks for that. I will try it right away.

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Andy Lacey
Sent: Thursday, April 08, 2004 7:30 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Linking speeds


The main one being to open a connection to the back-end and keep it open for
the duration of the relink, e.g.

Set dbData = DBEngine.Workspaces(0).OpenDatabase(strDataMdb)

As I can vouch, this speeds it up enormously.

--
Andy Lacey
http://www.minstersystems.co.uk



--------- Original Message --------
From: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Linking speeds
Date: 08/04/04 12:42

>
> Jim ...did you check the dba archives? ...this has several possible causes
> and solutions that have been covered extensively :)
>
> Political advertising is the price of our chains ...my name is William
> Hindman and I approve this message :)
>
> ----- Original Message -----
> From: "Jim Lawrence (AccessD)" <accessd at shaw.ca>
> To: "Access Developers discussion and problem solving"
> <accessd at databaseadvisors.com>
> Sent: Wednesday, April 07, 2004 10:57 PM
> Subject: [AccessD] Linking speeds
>
>
> > Hi All:
> >
> > I seldom use 'bound' forms in Access...SQL and Oracles work better
> 'unbound'
> > but this is not the question or a provocation.
> >
> > I am having a 'bound' problem with a slow connection/linking from the
FE
> to
> > the BE. The users do not seem concerned but the initial connection
times
> > seem unreasonable long. Some messages have been posted to this issue
on
> the
> > list but I missed them.
> >
> > Would anyone know how to speed up linking time? (Access2002)
> >
> > TIA
> > Jim
> >
> > --
> > _______________________________________________
> > 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
>
>
>
>
>

________________________________________________
Message sent using UebiMiau 2.7.2

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