Error after splitting database

[Rattlesnake]

hi,
I was confused as to where to submit this question so I put in the general section.

I converted an application in Access 97 to Access 2000. DAO 3.51 was used in the Access 97 app. While converting DAO 3.6 was automatically refrenced. The application was running fine.
Now I split the tables and the non-table entities using the "Database Splitter".
Now ,When I run the application it gives me an error :
"Operation is not Supported for this Type of object"
wherever i have used the "recordset1.INDEX" property. The recordset is declared and used as

dim recordset1 As Recordset.
recordset1.INDEX= idx.Name ** Error is on this statement

This error occurs only and only when I use the INDEX property of the recordset and nowhere else. And it only occurs when I split the database(it works fine when the tables and other ibjects are in one database).
Anybody has an idea on how to fix this???

Thanks a lot.

 

[R. Hicks]

Make sure that DAO 3.6 is enabled in the split databases after you use the Database Splitter.

HTH
RDH

 

[Rattlesnake]

hi,
I have ensured that DAO 3.6 is refrenced after the split. How is it that error appears only with the INDEX property?
I really need some help. My whole app is on hold.
Thanks

 

[Jeff Bailey]

From Help on Index Property

"You can create a table-type Recordset object from a base table of a Microsoft Jet database, but not from an ODBC or linked table."

Your problem is that the .Index object is an object in the Indexes (Indices?) collection of the TableDefs object (i.e. table-type recordsets) and you cannot have that with linked tables (it's similar to not being able tyo use Seek on linked tables).

HTH

Jeff

 

[Rattlesnake]

So is there a solution to this?
Or will I never be able to use the INDEX property ?

Thanks