[AccessD] Faster way to copy files

Christopher Hawkins clh at christopherhawkins.com
Fri Feb 20 16:31:08 CST 2004


I can't say for usre, but I'd bet good money that if you used that
same FileSystemObject approach in a VB6 .dll instead of from inside
Access, you'd see a marked performance improvement.

Just a thought.

-C-

---- Original Message ----
From: prodevmg at yahoo.com
To: ms-access-l at po.missouri.edu, accessdevelopers at yahoogroups.com,
ms_access at yahoogroups.com, accessd at databaseadvisors.com, 
Subject: RE: [AccessD] Faster way to copy files
Date: Fri, 20 Feb 2004 11:04:33 -0800 (PST)

>I have used both the CreateObject("Scripting.FileSystemObject") and 
>the MS Access FileCopy method to copy MS Access front end databases 
>from a network folder to multiple (upwards to 50) user home 
>directories and they are both too slow for me. 
> 
>Is there a faster method or any optimizing tips anyone can share?
> 
>Thanks again to the Gurus of the Tech World!
>
>
>
>Lonnie Johnson
>ProDev, Professional Development of MS Access Databases
>Visit me at ==> http://www.prodev.us
>
>
>
>
> 
>
>
>
>
>---------------------------------
>Do you Yahoo!?
>Yahoo! Mail SpamGuard - Read only the mail you want.
>_______________________________________________
>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