Chris, Face it, you are trying way too hard to stay in the dark ages . . . SQL is your friend!
Okay, a brief tutorial follows: 1) create you table in Access and try to make sure you have at least a Primary Index (if nothing else, stick an AutoIncrement column in the table and set THAT as the PK); 2) Use ADOConnection, ADOQuery, and, if need be, DataSource components to connect to and access the data; 3) Learn SQL! The simplest SQL statement is probably SELECT * FROM yourtable but you can add a WHERE clause to select only the rows/records you really need. Without your attempt at SQL and how you attempted to implement the access to the database, I cannot even begin to guess how you got that error message . . . I have never seen it before. At 11:54 PM 1/22/2007, you wrote: >Hi All, > >I've avoided using SQL now for many years as I really don't want to >spend the time to learn that stuff. Flat files or a simple >master-detail are really good enough for me. > >But... I need an alternative. I've been using Absolute database but >their filtering performance is well behind the rest. I'm thinking of >Access but I seem to be having trouble using indexes as I get a >"current provider does not support the necessary interface for Index >functionality" error. > >Can anyone advise a suitable alternative? I'm using D2005 although I >do have access to D2006. > >Standard application for me is a flat file table with 500,000 records >around the 100Mb mark. I need to be able to filter and run analysis >on the filtered table. I use the raw filter strings as this gives me >the most flexibility - perhaps it's just because I'm used to it. > >Cheers, >Chris. > >_______________________________________________ >Delphi-DB mailing list >Delphi-DB@elists.org >http://www.elists.org/mailman/listinfo/delphi-db Ralph D. Wilson II Systems Analyst [EMAIL PROTECTED] [EMAIL PROTECTED] _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://www.elists.org/mailman/listinfo/delphi-db
