[AccessD] Access 97 Application Startup

DWUTKA at marlow.com DWUTKA at marlow.com
Wed Mar 3 10:59:18 CST 2004


Token ring?  Are you serious?  That is more then likely an issue.  Is your
copy split BE and FE?  Or are you using the 'full' database?

That is definitely an issue for speed, by having the FE/BE shared.  Do you
have any startup code/forms?  If you don't, and it just takes that long to
open the .mdb itself (try holding shift down during opening, see if that
makes a difference.  If it does, then you have something running in the
beginning.....), the only thing I could think of to optimize things, is if
you have Access User Level security running, make sure to use a local .mdw
for the user's FE, because that is one less thing Access has to access the
network for.

Token Ring is a very sluggish network process though, if I remember right,
it literally goes 'round and round', looking for network messages to handle,
instead of the self perpetuated methods of Ethernet and TCP/IP.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Barbara Ryan
Sent: Wednesday, March 03, 2004 9:46 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Access 97 Application Startup


The application loads in 20 seconds on my computer.  My client says the
application takes 2 minutes to load on his machine, which is connected to 3
other computers via token ring (the backend database is shared).  This
morning, however, he said the app took 20 seconds to load, but nobody else
was on the network.

I don't think he uses Outlook, but I'll check.

Barb



----- Original Message ----- 
From: "Eric Barro" <ebarro at afsweb.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, March 03, 2004 10:26 AM
Subject: RE: [AccessD] Access 97 Application Startup


> I'm going to assume that you are also running Outlook. If so check if
Journal is activated. This often slows down loading Office apps.
>
> ---
> Eric Barro
> Senior Systems Analyst
> Advanced Field Services
> (208) 772-7060
> http://www.afsweb.com
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Barbara Ryan
> Sent: Wednesday, March 03, 2004 7:17 AM
> To: Access List
> Subject: [AccessD] Access 97 Application Startup
>
>
> What is actually happening "behind the scenes" when an Access 97
applications starts up?  What are some things that would cause the same app
to start up slower on one machine vs. another?  Does anyone know of any good
documentation of this on the web?
>
> Thanks,
> Barb Ryan
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.593 / Virus Database: 376 - Release Date: 2/20/2004
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.593 / Virus Database: 376 - Release Date: 2/20/2004
>
> -- 
> _______________________________________________
> 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



More information about the AccessD mailing list