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
>
>