Darren D
darren at activebilling.com.au
Tue Feb 19 23:36:37 CST 2008
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