Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Access
3rdpartyusrgrp
access
activexcontrol
adp.sqlserver
commandbarsui
conversion
dataaccess.pages
developers.toolkitode
devtoolkits
externaldata
forms
formscoding
gettingstarted
internet
interopoledde
macros
modulescoding
modulesdaovba
modulesdaovba.ado
multiuser
odbcclientsvr
queries
replication
reports
security
setupconfig
tablesdbdesign
  
 
date: Fri, 27 Jun 2008 14:27:32 -0600,    group: microsoft.public.access.modulescoding        back       


Re: Active x component can't create object (unless an MDE file)   
"Douglas J. Steele"  wrote:

>It shocks me that you'd get better performance. As I wrote in Access Advisor 
>( http://my.advisor.com/articles.nsf/aid/16279 ), typically using VBA is an 
>order of magnitude faster than using FSO, and using APIs is an order of 
>magnitude faster than using VBA. (In finding 5491 files on my hard drive, 
>the API approach took 0.191 seconds, using the Dir function took 1.222 
>seconds and using FSO took over 10 seconds).

Very interesting.  I've almost always used API calls.  I've never
quite trusted FSO.

Tony
-- 
Tony Toews, Microsoft Access MVP
   Please respond only in the newsgroups so that others can 
read the entire thread of messages.
   Microsoft Access Links, Hints, Tips & Accounting Systems at 
http://www.granite.ab.ca/accsmstr.htm
   Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
date: Fri, 27 Jun 2008 14:27:32 -0600   author:   Tony Toews [MVP]

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us