Strange Error with Split Database

[poet1234]

Hello. I just split my Access 2000 database and receive the following Run-time error (#3251): Current provider does not support the necessary interface for Index functionality. This error occurs on the following line of code: tablename.Index = "PrimaryKey"

Does anyone know why this occured after I split the database and what exactly it means?

Thanks in advance.

 

[KeithG]

Not sure have you tried a compact and repair? Or maybe check for a missing reference?

 

[The_Doc_Man]

Split in which manner? FE/BE is Access? Or FE is Access, something else is BE?

 

[poet1234]

FE/BE both in Access 2000

 

[The_Doc_Man]

Is this possible a trial version of Ac2K? Or a student/teacher version? Something other than a full install?

 

[poet1234]

Hi. It's the full sha-bang -- the developer version. I have always heard that splitting the db is beneficial. I suppose I could remove those index references (I didn't write that particular code. I have never set up an index in code and was wondering if it would hurt to just remove it). Thanks.

 

[Fear Naught]

I would have thought it is because you now have linked tables from the BE database. Setting up an index (even if only temporary) will possible be trying to changed the definition of the table which can't be done in a linked table.

Greater minds than my own may throw more light on this problem.

 

[gemma-the-husky]

you cant use indexes/seeks etc directly in an attached (ie split) database

you either need to open the be database directly using dbengine.workspaces(0) syntax - this is probably not quite right syntax, but help should show you how to go on - or use find operations, instead of indexed seek operations, which are a bit slower.