Hi Dan,
The application is actually only aimed as a single user application. But there will be different users setup in the system, so only one connection will be made at a time. Access is starting to sound better and better... Unless I can get Firebird to install easy... Still deciding though. But some examples with the access DB would be much appreciated. Thanks. --- In [email protected], GreatDayDan <[EMAIL PROTECTED]> wrote: > 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/
