Fastest read access?

S

sjn78

Well-known member
Joined
May 4, 2003
Messages
255
Location
Australia
This is a 2 part question.

I have never used xml, so some of these questions may seem stupid to some of you.

Can xml be used in the following fashion,

Can it contain multiple datasets? I have only really had experience with Access, so what Im getting at is that for each table you would create in Access, do you need to have seperate xml files.

And the second part of the question is,

What is the quickest method for reading data into an app. Reading a database, xml or text file.

The program I am writing has multiple tables in Access. I dont know whether I should keep them in access or use xml or a text file.

Any comments or suggestions would be a great help

Steve
 
That is not possible as this is an application to run on individual home computers. So access, xml or text files are the only possibility.

Not too sure about MSDE. You said MSDE is free, I gather it is available from Microsoft? Something I will look into.
 
MSDE is the desktop version of SQL Server. It was built for applications like yours and is very easy to install alongside your software. You should look into using it over the other options youve outlined. If it turns out for some reason you cant or wont use MSDE Id stick with Microsoft Access, since XML and text files just arent scaleable.
 
Back
Top