Good Morning! Please let a lurker jump in.
Will this be a client/server application? With a central db and multiple users? If there will not be more than about 10-15 users connecting at the same time, then an Access db could work. The server does NOT need to have MS Access installed. The only thing needed is MDAC 2.8. This is available from MS and is 'free'. Then, create your db (either with Access on your dev computer or via code in a seperate application) and copy it to the server. Use an ODBC connection to access the Access db. I can send you examples of how to create the db and the ODBC connection via Delphi. A warning about Access: it will not compact itself. You can do so manually or via code. If you have many updates and deletes, the db can grow pretty big. I also like Firebird. But it is not as easy to install. HTH...Dan'l --- custom_soft_sol <[EMAIL PROTECTED]> wrote: > > > Hi Katja, > > Yes, I do know that XML is not a true DB, the reason > I thought of it > was because it is free :) > > My options at this point are Firebird, MSSQL 2005 > Express, XML and > Access. > > I really would rather not use access though. I would > love to use > MSSQL 2005 Express, but then I need to get a very > easy way of > installing it silently and being able to maintain it > from within my > application (which should not be too bad as I have > done it before). > > Are there any other ideas that anyone can help me > with? > > Thanks > > --- In [email protected], "Katja Bergman" > <[EMAIL PROTECTED]> > wrote: > > > > Hi, > > > > I myself am just a student so I know what you mean > with 'free, > easy > > installation and maintenance'. :-) That does limit > your options a > bit, > > though. > > One thing that you'll have to keep in mind is the > design of your > > application. How many people will be accessing the > database at the > > same time, for example? Would those users actually > need straight > > access to the data too? Or would their only access > to the data be > > through your application? > > > > About XML... You do realise that XML isn't a real > database format? > > It's just a storage protocol for data and often > useful for simple > > configuration files or to exchange data between > multiple > applications. > > > > Interbase and MySQL are good, free options but not > too easy to > > install. But if you have installed MS-Office then > Access might > also be > > an interesting alternative. All you need to work > with Access is > ADO > > and of course the database file with your data > inside it. And it > would > > allow users to access the data directly too. > > Access has one other good thing, though. While you > have to pay for > the > > product itself, distributing ADO and your Access > database files is > > just free of charge. So your users wouldn't have > to pay for Access > if > > they just use your application. Besides, Office is > a very popular > > product too. > > > > Access is also pretty easy to maintain and > install. I know that > > especially Delphi developers who are used to DBase > or Paradox > consider > > it a moral sin to even consider using Access but > it cannot be > denied > > that it's a very good alternative. > > > > With kind regards, > > X Katja Bergman. > > > > > > ----------------------------------------------------- > Home page: http://groups.yahoo.com/group/delphi-en/ > To unsubscribe: > [EMAIL PROTECTED] > Yahoo! Groups Links > > > [EMAIL PROTECTED] > > > > > > ____________________________________ Every day is a Great day, but some days are GREATER than others! __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/ ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
