I've got these 3 old VB 3.0 programs that our company is maintaining (but that's another story all together )
One of the apps refuses to compile, even though the code it is choking on, is exactly the same in all 3 apps. There is a variable declaration:
Global ds As Dynaset

Then in the code, a little something like this:
Code:
    sql = "select count(*) from tempdb..mp_eac"
    sql = sql & " where dat_ty_cd='S'"
    Set ds = db.CreateDynaset(sql, 64)
    sup_rec_count = ds(0)
When I go to run this app from the dev environment I get the following error, "Object is not an array". With the "ds" in the last line listed above highlighted.

I checked the code in the other programs and it is identical, any clues?