Means I have to have 2 different database access methods, although I guess that's not so bad now - have to get out of the COM mindset and think assemblies...
Thanx for the heads up - might well be the best option. Dino -----Original Message----- From: The DOTNET list will be retired 7/1/02 [mailto:[EMAIL PROTECTED]] On Behalf Of Brad Wilson Sent: Friday, 7 June 2002 09:49 To: [EMAIL PROTECTED] Subject: Re: [DOTNET] Using DataSets as an IMDB Dean Cleaver wrote: > I have a project that the client wants to be able to operate in a > corporate environment with many users on SQL Server, and also in a > standalone environment (I don't mean these users working offline, I > mean a "1 user site") without SQL Server. > One thought I had was to create XML files for all the data, and then > load them one by one into a DataSet and then add the foreign keys etc > to effectively create an IMDB - but does that allow me to select out > based on a query or anything? Can I select a "view" based on a couple > of data tables in a dataset? Why not Jet (Access .mdb file)? Brad -- Read my web log at http://www.quality.nu/dotnetguy/ You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com. --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.370 / Virus Database: 205 - Release Date: 05/06/2002 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.370 / Virus Database: 205 - Release Date: 05/06/2002 You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.