Re: searching for the right dbm ...

In article <338C3840.360D@iperbole.bologna.it>, Andrea Frascari <mir5360@iperbole.bologna.it> writes >Hello, > >I'm developing an application that will manage medium amounts of data. >The analysis is completed, and it's now time to undertake some >architectural >decisions, such as which database to use. >The application will run on Windows 95 and NT. >What follows is a list of the main features the database is supposed to >have: >- cost: free for the end users. We need an "unlimited" licence. >- ODBC support >- SQL-based >- sicurety: hi, transaction support required: the application will >manage big > money transfers ! >- performance: hi retreival and insertion speed: the number of records >will > not be huge though (biggest tables around 25,000 recors). > >Any suggestion? >What do you folks think of Microsoft Access for instance? Does it come >with >an "unlimited" licence? > >Any information, opinion, address towords other information sources is >very welcome! > Access is not good for more than one user accessing the database as it uses page level locking hence you in a real application (not some noddy app with one user running it) you will get locking problems. We had a site which has an application running on Access, we came in and rewrote it using VB (I prefer Delphi) + Informix. With only 80 users it was faster and they had virtually no locking problems. >Thanks in advance. > >Andrea Frascari - e-mail: mir5360@iperbole.bologna.it -- David Williams