datastore for my application?

Hello, i am creating an application thats is going to require alot of information to be saved for persistance. There are many options available to me but i need to ask a few questions on things i am unsure on

XML

I need to be able to append and remove data from the saved info, this seems near impossible without a dirty hack when it comes to well formed XML. i looked into using XML fragments, however this becomes tricky when i try to read the data back in

Database

This is i guess is the ideal solution and i could use an MS Access DB to save the info. The only drawback here is that the DB is 150k before i even begin put in any data to it :(

So what id like to know is if there are any better methods than these outlined above, and also, if i use Access, does this mean a users PC will need extra software in order to run the application (namely MS Office/Access + JET drivers )

Many Thanks
Ash

Answer this question

datastore for my application?

Haashole
Thanks for your reply,
Aam i to take 'embedded mode' as meaning that the the end user does not need to have the DB application installed Everything required to access and modify a given DB file will work through a DLL in the c# application

Also, does this work for Access

Many Thanks
Vince_Kennedy
an alternative to Access is FireBird http://firebird.sourceforge.net/
it is an opensource free database
it can also run in embedded mode
basicToddler
What a fantastic piece of kit. Thanks LiFo!
DCMonkey
yes the database server is in an dll so you only need to have the dll in the same folder as your application
and an db file somewhere

no i dont think it works for Access
datastore for my application?

Answer this question