[AccessD] Slow Openers

Tue Feb 19 23:48:06 CST 2008

Thanks Darren.

At 20/02/2008, you wrote:
>Hi David
>
>As far as I know - no - but if it can be done - Someone here will know :-)
>
>However - I am in the same position as you
>Laptop at work - Into network drives all day
>Take laptop home - and things slow down
>So I just have a batch file I double click in the morning when I get to work
>And one I double click in the evenings
>
>This of course can be automated through access and the batch files made to run
>'hidden'
>You can even shell the commands from access - No need for batch files
>But I like to keep it in one file for portability outside Access
>
>There are quite a few ways to achieve this - I use this method for its ease
>
>Something like
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Rem MakeConns.bat
>@echo off
>cls
>net use N: \\ ServerNameHere juliet\EDrive\ClientFolders
>net use W: \\ ServerNameHere juliet\CDrive
>net use H: "\\ ServerNameHere hoseb\RAID5_01 (G)"
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Then to "kill" 'em one by one
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Rem KillConns.bat
>@echo off
>cls
>net use /DELETE N: \\ ServerNameHere juliet\EDrive\ClientFolders
>net use /DELETE W: \\ ServerNameHere juliet\CDrive
>net use /DELETE H: "\\ ServerNameHere hoseb\RAID5_01 (G)"
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Rem KillAllConns.bat
>@echo off
>Cls
>NET USE * /DELETE
>Rem un-rem the line below to do it without being prompted
>Rem NET USE * /DELETE /Y
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>Hope this helps
>Have a great day
>
>Darren
>-----------------
>T: 1300 301 731
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
>Sent: Wednesday, 20 February 2008 3:37 PM
>To: Access Developers discussion and problem solving
>Subject: Re: [AccessD] Slow Openers
>
>Is there any way to have explorer not check for disconnected drives
>unless you specifically click on them.  I have a number of these
>which are used infrequently.  It would be nice not to have to map
>them each time I want to use them, but also not to have the delay
>every time I want to explore folders, open a file etc.
>
>David
>
>At 20/02/2008, you wrote:
> >ooohhh good one.  Generally that only affects explorer operations though,
> >not the opening of the application itself.
> >
> >
> >John W. Colby
> >Colby Consulting
> >www.ColbyConsulting.com
> >-----Original Message-----
> >From: accessd-bounces at databaseadvisors.com
> >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Eric Barro
> >Sent: Tuesday, February 19, 2008 9:29 PM
> >To: 'Access Developers discussion and problem solving'
> >Subject: Re: [AccessD] Slow Openers
> >
> >Do you by chance have any disconnected network drives?
> >
> >-----Original Message-----
> >From: accessd-bounces at databaseadvisors.com
> >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
> >Beach Access Software
> >Sent: Tuesday, February 19, 2008 6:08 PM
> >To: 'Access Developers discussion and problem solving'
> >Subject: Re: [AccessD] Slow Openers
> >
> >Would that the problem were that easy.  I could live with it.
> >
> >Rocky
> >
> >
> >
> >
> >
> >
> >
> >
> >-----Original Message-----
> >From: accessd-bounces at databaseadvisors.com
> >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
> >Sent: Tuesday, February 19, 2008 5:30 PM
> >To: 'Access Developers discussion and problem solving'
> >Subject: Re: [AccessD] Slow Openers
> >
> >Toooooo muuuuuuchhhhhh vaaaaaaaaaliiiiiiiiuuuuuuuum?
> >
> >;-)
> >
> >
> >John W. Colby
> >Colby Consulting
> >www.ColbyConsulting.com
> >-----Original Message-----
> >From: accessd-bounces at databaseadvisors.com
> >[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin at
> >Beach Access Software
> >Sent: Tuesday, February 19, 2008 5:58 PM
> >To: 'Access Developers discussion and problem solving'
> >Subject: [AccessD] Slow Openers
> >
> >Dear List:
> >
> >Suddenly (well over the past couple days) Access, Excel, and Word are
> >opening slowly - like 30 seconds.  This is a P4 3GHz box w/ 2GB Ram.  What
> >would be the most common things to look at for a cause of slow openings?
> >
> >MTIA
> >
> >Rocky
> >
> >
> >
> >
> >
> >--
> >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
> >
> >No virus found in this incoming message.
> >Checked by AVG Free Edition.
> >Version: 7.5.516 / Virus Database: 269.20.7/1286 - Release Date: 2/18/2008
> >6:49 PM
> >
> >
> >--
> >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
>
>No virus found in this incoming message.
>Checked by AVG Free Edition.
>Version: 7.5.516 / Virus Database: 269.20.8/1287 - Release Date: 19/02/2008
>10:55 AM
>
>
>No virus found in this outgoing message.
>Checked by AVG Free Edition.
>Version: 7.5.516 / Virus Database: 269.20.8/1287 - Release Date: 19/02/2008
>10:55 AM
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com