My program needs to start auditing saved XML data for users. Whenever the user clicks 'Save'; I'll need to insert his current data (serialized to XML) and save it somewhere. What is the better option between:
I'm using .Net 2.0 / MS Access 2003
The benefit of using tables in any DBMS over file storage :
With xml files on the file system, you will need to come up with strategies for 'unique file naming' and overcome limitations of how many files you can store per folder etc.
In some RDBMS', Xml is a first class data type (unfortunately, not for MS Access), so:
However, in Access, you will need to store in a Memo field, with a maximum document size of 1Gb in Access 2010.
TL;DR : If you are already using a database, store the Xml in it.