VB6+DAO+MDB_OnSharedFolder -> Error 3420: Object invalid or no longer set
Posted on 2006-07-11
I have a vb6+dao app, mdb database on a shared folder, after a few weeks on a LAN (8 PC's network), the MDB that is about 40 MB's.
I get error 3420.
I never set rs = nothing, I never use rs.close
I suspect that this could be a corrupted database. So my question is, could error 3420 be a symptom of a corrupted database? Or just a lost connection (maybe over a wireless network?).
If it is a corruption problem, is there any tool to analyze for errors? I use compact-repair but it never tells what kind of problems it found. So I would like a better tool/alternative.
Any help would be great!!