I am a newbe with Delphi 2009. I have created a simple application with one form. I am using components fro the dbGo library. I am displaying a table from an Access .mdb file. The TADOConnection is using the following ConnectionString:

Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data Source=C:\Projects\FragentOpsVP\Data\FragentOps2002.mdb;Mode=Share Deny None;Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False;

Everything seem to work well. That is, until I try to set an index in the TADOTable. The IndexName drop down shows the indexes that are in the database for that table. When I select the Index I want I get the following error message:

"Current provider does not support the necessary interface for Index functionality."

What exactly does this mean? I find it hard to believe that Jet.OLEDB.4.0 does not support indexes. How can I get around this? I really would like to use Access databases.

Delphi 2009 is running under Vista 64 bit edition.

Thanks for any insight,

William 

w_keller wrote:
> 
> "Current provider does not support the necessary interface for Index 
> functionality."
> 

> Delphi 2009 is running under Vista 64 bit edition.



You have so excellent error message above! And you also know the db
tools you are using by name. 

Why not put these two items to Google and see what you get. 

You'll notice you are not alone with this Access error. But also that
there probably is not much you directly can do by hacking your lines of
Delphi code. 
DB-1

did you ever find the answer for this - I am having the same problem in delphi 2010

I found it - close the dataset, change the index name, then activate the dataset.   *Important* - you must set tabledirect to true for the index to have any effect