I have an Access database with many linked fairly large tables. The
linked tables are linked to native Access tables in other mdb's. The
performance is slow when I do a query against these tables. We use
DAO. I don't know what version of Jet I am using. How would I find
this out and does it matter what version of Jet we are using? If so,
why? I know it is an Access97 database. Can I use the new ADO rather
than DAO to improve performance? I don't know about ADO yet. Could you
give me some insight? Would OLEDB come in to play here? If so, where
and what is it? If I rewrote this application in VB 6.0, do you think I
would see performance gains over the Access application.
Thanks,
Keith