On one of my Access tables, which has about 40 columns, I have to wait several minutes! On smaller tables much less. I am on broadband and never had this problem before. The problem is worst when using INSERT RECORD dialog. Sometimes, after waiting all that time, the column field is still not populated and I have to start all over.
I read old messages here and one person who had this problem was using 10 recordsets on a single page. I am not doing that. Just one recordset.
Does anyone know why this happening?
Could this mean that my Access 2000 database is corrupted? Is there a tweak ?
Oh, forgot to say: the database is on remote.