Array of databases

I am trying to build a dynamic array of a variety of database objects. Would I be correct in assuming I should delclare the array as a variant

dim dbs(-1) as varient

Then add multiple objects like

dbs.append SQLdatabaseMBS
dbs.append sqllitedatabase

etc etc? not having any luck with this method.

Gawd no not Variants

Since ALL databases are subclasses of Database declare it as an array of Database

dim dbs(-1) as Database

Then add multiple objects like

dbs.append SQLdatabaseMBS
dbs.append sqllitedatabase

I would suggest you rather locate database on a session, webpage/window where it is needed and not in some huge global array.

You get compile errors because array is Database type (I presume). Please try with locale SQLDatabaseMBS variable and later stuff it in your array.