Access 2002 Provider Question

[Carl]

I've run across something that did not seem to be around
in Access 2000 - the current provider. When trying to
set an active index for an open table I get the
error "Runtime error 3251: current provider does not
support necessary interface for index functionality."
The code I am using is:

Set rst = New ADODB.Recordset
Set cnn = New ADODB.Connection
Set cnn = CurrentProject.Connection
rst.Open "tblTransactionFile", cnn, adOpenDynamic
rst.Index = "Master"

I get the above error after entering the last line. I
have tried opening the table using "adOpenKeyset" with
the same results.

Am I correct in assuming that the provider information is
new to Access 2002?

Thanks,
Carl White

 

[Guest]

I'm still very new to Access, but try using ADOX.

 

[Carl]

I did try that but got a different error: "user defined
type not defined."

Carl