I created a program using VB6 and ADO.  I am using an OLE grid to
display information and I have several button that toggle different
queries to display in the grid.  The grid is bound to the ADO data
control.  I use a connection string to connect the ADO control to the
database.  The information is being stored and queried in Access 2000.

The query returns the information in under 1 second, but as soon as
another user accesses the database, the query slows down to over 3
seconds.  This may not seem too bad, but it's painfully slow to the
program.

Am I missing a setting somewhere?  Why such a slow down?  Please give
me an ideas, facts, or thoughts.  I have searched Deja.com and
Microsoft for answers but I haven't found the answer.

Thanks,

Rick

Sent via Deja.com http://www.*-*-*.com/
Before you buy.

If so, that is your problem. Use Jet 4 and all your problems are gone.