Im using DAO to access a database file which contains 92,000 records. Problem is thats it seems very slow performance wise.
The below line causes a 2-5 second pause which is fairly bad. Is there any way to improve things? Would using more tables instead oh having 92,000 records help?
Or would ADO be better?
Set myrs = db.OpenRecordset(strsql, dbOpenDynaset) ' Causes BIG Pause