Hi Rob,
> I'm using ADO and "Microsoft.Jet.OLEDB.4.0"
> I know that that 3.51 may be a bit faster, but there was some
> reason (memories ?) that I went 4.0
Since you are already using ADO/OLEDB then the learning curve in switching
to MSDE is smaller than you might think. Sure, MSDE has some features (like
stored procedures) that aren't in Access but there is no rule that says you
need to use them. And you can still use access to prototype queries, if
you're more comfortable with it.
Is your server being used for other tasks (eg a mail server) that might be
flushing the file cache between database requests?
Adelle.
'// =======================================================
Rules : http://ReliableAnswers.com/List/Rules.asp
Home : http://groups.yahoo.com/group/vbHelp/
=======================================================
Post : [email protected]
Join : [EMAIL PROTECTED]
Leave : [EMAIL PROTECTED]
'// =======================================================
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/vbhelp/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
