DB question - File DB's

[Drakkon]

Currently when distributing products we've been using access and x12 to create file databases that can be put on a CD and then from within the program can use "select * from table" and that sort of thing. Access sucks and x12 is just too wierd to work with so i was wondering if there are any others out there? So long as it has an ODBC availibility usually good to go...
Systems aren't online and no sys privilages so can't use MySQL, posgre, oracle, etc
XML would get me there if i had a way to select certain columsn at different times...XML works great when processing data retrieved from a db but i can't find a good way to easily get just one row of an xml db

 

[Drakkon]

no one has any input?

 

[CycloWizard]

You can do it with XML, though I'm not sure how efficient XML databases are. I had to do this at some point so I know I have the code around somewhere. If I don't post it by tomorrow, PM me a reminder and I'll dig it out.

 

[Templeton]

You can use sqllite
There's an ODBC driver available here (been beta for quite sometime... could probably be used in production, but you'd really need to test first).