Recordset Catalogs

I am trying to use this to open a Table name and I keep getting ERROR 3265

Public Record_Set(30) As New ADODB.Recordset
Public Catalogs As New ADOX.Catalog

Record_Set(21).Open Catalogs.Tables("STATEMENT").name, Data_Connection(10), adOpenStatic, adLockOptimistic, adCmdTableDirect

Error is

Item cannot be found in the collection corresponding to the requested name or ordinal.

Now I Can Assess the Database uning Access2000

But Not In VB

Any Suggestion

Hi,

is there any specific reason you're trying to use ADOX here?
When the same can be achieved as follows:


rs.Open "Select * From TableBla",conn, adOpenStatic, adLockOptimistic

Thanks Learn something HOW to open a table

Oh this is driveing me Dam NUTs can not get this to work. Been trying to get this for 4 days.

Been trying ever combination I can think of.

Got it to work once but would not do what I wanted.

Data_Connection(10) is open

Set Record_Set(21) = New ADODB.Recordset
Record_Set(21).Open "Select * From Statement", Data_Connection(10), adOpenStatic, adLockOptimistic
Set S1S = Record_Set(21)

Any Suggestion as to why I get error 3709

What's S1S?

You have arrays of connections and arrays of recordsets?

How many database files are you opening?

You are aware that a single connection supports an unlimited number of recordsets in a given database?

And, that connections are especially resource intensive to create and maintain? Recordsets are "expensive," too, but not as "expensive" as connections.