Alternative Index D5,Ado, and Access2000

Peter McIntyre

Delphi Developer

Mon, 02 Dec 2002 03:00:00 GMT

Alternative Index D5,Ado, and Access2000

I have not seen a post for anyone else having this problem so I assume I
am doing something wrong, maybe someone can guide me in the right
direction.

I am using Delphi 5 with ADO Express on an Access 2000 .MDB.

The problem is that the AdoTable component always display records in
primary index order even when I select an alternate index on the
properties page. I am using a server side cursor.
Any suggestions?

Vassil Nazaro

Delphi Developer

Tue, 03 Dec 2002 03:00:00 GMT

Re:Alternative Index D5,Ado, and Access2000

Unless you have a special reason to use TADOTable you
should use TADODataset and TADOCommand.

HTH
--
V. Nazarov
IT Manager, Sofia Cable

Quote

"Peter McIntyre" <disw...@home.com> wrote in message

news:3948FC8B.68F07D14@home.com...

Quote

> I have not seen a post for anyone else having this problem so I assume I
> am doing something wrong, maybe someone can guide me in the right
> direction.

> I am using Delphi 5 with ADO Express on an Access 2000 .MDB.

> The problem is that the AdoTable component always display records in
> primary index order even when I select an alternate index on the
> properties page. I am using a server side cursor.

> Any suggestions?

Michele Bersin

Delphi Developer

Fri, 06 Dec 2002 03:00:00 GMT

Re:Alternative Index D5,Ado, and Access2000

Use IndexFiledNames insted of IndexName

Michele

Other Threads

1. D5 ADO to Access2000 Default Parameter Errors

2. database update problem with D6 ADO/VCL, ADO v2.6, and MS Access2000

3. Problema Con index en ADO (Problem Ado Index)

4. Locking records. D5 + Access2000

5. D5 Problem with Access97 table (Access2000 installed)

6. Locking records. D5 + Access2000

7. D5 Ent. + MSDE (Access2000) Issues

8. D5 and Access2000???

9. Problem with access2000 and foxpro table with index

10. ADO with MSSQL2000 and Access2000