The following source code are in VB6, and trying to access to Microsoft DB (.mdb) file. The code failed on .Recordset.BOF, I got the error message: "Error in loading dll".
If .datLocalQueue.Recordset.BOF And .datLocalQueue.Recordset.EOF Then 'no records
numLocalQueueRecords = 0
numLocalQueueRecords = .datLocalQueue.Recordset.recordcount
I tried to fix it last time, I copied the DAO350.dll from another PC, it works fine last week. For some reason, it failed again. I did search on this topic, it suggest me to uninstall Microsoft office 2000 Professional and reinstall it, I did that, I still have the problem.
Can someone suggest something else for me to try it?