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