Index Error

[121410]

Here is my problem

I use VB6.0 and Access 2000
My Code is
Set cn = new ADODB.Connection
Set rs = new ADODB.Recordset

With cn
.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "Test.mdb"
.Open
End With

rs.Open "Select * from Test",cn, adOpenDynamic, adLockOptimistic
rs.Index = "Test"

When run above code, error " Member or data member not found" occur at "Index" property

Can you tell me why and how to correct it???

 

[MatsHulten]

Don't know if this is it, but the index must be previously defined in the DB, either via ADOX or from within Access.
If you are trying to referense a field that is not previosly defined as an index, this will give you a runtime error.

Also, I noted you are using Test both as the field name, and as the table name. This is not a problem, but you do have a field within the table Test that has the name Test, don't you? (Just checking.

Good Luck
-Mats Hulten

 

[MichaelRed]

Actually, "Test" appears to refer to:
[tab]The db name
[tab]The Table Name
[tab]The Index Name.

Field name(s) are not explicitly given.

but MatsHulten's point is still valid

Each of the Objects with the NAME "Test" must be re-incarnated (have a 'prior') existance.


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[121410]

Now my Code is

Set cn = new ADODB.Connection
Set rs = new ADODB.Recordset

With cn
    .ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & "myDatabase.mdb"
     .Open
End With
     
rs.Open "Select * from myTable",cn, adOpenDynamic, adLockOptimistic
rs.Index = "myField"

When run above code, error " Member or data member not found" still occur at "Index" property

Can you tell me why?