in message
: Roland Hall wrote:
: > "Bob Barrows [MVP]" wrote in message
: > : >> js wrote:
: >>> Hi, I have some questions about replace with mdb file with xml file:
: >>
: >> Don't
: >>
: >>> Can I use ado
: >>
: >> ado is not needed to use xml
: >>
: >>> and xml to store info instead of Ms access database,
: >>
: >> Yes, but ....
: >>
: >>> what will be the diff?
: >>
: >> No referential integrity. No SQL language. No data constraints. xml
: >> is simply a text file.
: >>
: >>> can ado and xml support mult-user
: >>> Concurrent access? Thansk...
: >>
: >> No. You will wind up having to reinvent the wheel with your own
: >> code. it's not worth it.
: >
: > Not sure what you're saying here Bob. Are you saying using an XML
: > file on the net with multiple users is a bad idea?
:
: I'm not sure if this is a facetious question or not, but I'll answer it as
: if it is a straight question, given that I may have over-made my point.
I know I kid around a lot but it was a straight question.
: So, "Are you saying using an XML file on the net with multiple users is a
: bad idea?"
:
: A. Not necessarily.
:
: I'm saying that replacing a database, which provides the builtin
: functionality to support multiple users and protect the integrity of the
: data it contains, with a text file, xml or csv, may not be a good idea. It
: forces the developer to reinvent the wheel, writing all the code to
provide
: the same functionality that was provided by the database. Consider the
years
: it has taken the developers of Jet to get to the point they are at now, as
: well as all the mistakes that were made and corrected along the way.
: Providing that functionality is not an easy task. Not impossible, but
: definitely daunting.
:
: However:
: Using a read-only (or update-rarely) text file (or xml document stored in
: application or session) to cache frequently used, relatively static data
is
: a very good idea. In a perfect world, the data would still come from a
: database, but with truly static data, that is not necessary.
So, if a read-only XML file is shared and RW XML files are separate for each
user, that's not an issue? I'm asking because I'm doing that in lieu of
using an Access database and getting good results. I will however be
offering multiple database versions but for now, just XML.
--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center -
http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation -
http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library -
http://msdn.microsoft.com/library/default.asp