You might check out NexusDB; they have a free embedded version. www.nexusdb.com
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Stebbing Sent: Monday, January 22, 2007 9:55 PM To: Delphi DB List Subject: Database Alternatives 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 _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://www.elists.org/mailman/listinfo/delphi-db
