Posts Tagged ‘Recordset.RecordCount’

Run-time error ‘91′ on RecordCount

Tuesday, March 17th, 2009

Application developed in visual basic 5 works fine on all computers until today. I got the following error when I tried to run the application Run-time error ‘91′ Object variable or with block variable not set on computer with new OS installation.

I found out that the problem is connected to the following statement:

data1.Recordset.RecordCount

Solution: Check out if DAO is installed.

1.Make sure you have the following file:
C:\Program Files\Common Files\Microsoft Shared\Dao\Dao350.dll

2.Copy C:\Program Files\Common Files\Microsoft Shared\Dao\ directory from working computer

3.Register Dao in registry

Regsvr32.exe “C:\Program Files\Common Files\Microsoft Shared\Dao\Dao350.dll”