Best Database Software
images
images
images
images
images
images
images
images
images
images
User #148981 333 posts
semiold
Forum Regular
I work in a small clinical unit, and has a database shared by 3 computers. Since we are only given MS Access, we are using it. We put the database in the main server in a folder shared by all team members. We run Windows XP or 2000 in our PC. However it is very slow to load from the server to start the program. There are also problems, e.g. the linked table sometimes may not synchronize, while it works ok for other times.
The database is basically storing information about our clients, including follow up data. It consists of several tables linked together.
Could anyone recommend a freeware software or a database software not too expensive e.g. up to $400, that can be used to develop a better database than Access? It should be userfriendly and easy to be programmed.
Someone recommend Alpha five or Filemaker to me. What is your opinion and experience? I understand IBM and Oracle have free version, but are they difficult to write a multi-user application?
Thanks for all advises.
reference: whrl.pl/RbiZ6e
posted 2007-Sep-19, 6pm AEST
User #61010 18276 posts
The Elite Geek
Whirlpool Forums Addict
Aye, me recommend Mysql, though in production you should test the situation thoroughly and understand the workin's o' the database you use.
Many applications be easily ported from database ser'er t' database ser'er.
You might be better off with a web application, t' sa'e on creatin' a program usin' a Ui. Web applications be quicker t' program o'er regular applications, be accessible t' all Pcs, don't require any installation, and be updated with e'ery page load, compared t' a Pc application which will only update when requested. Gar, Where can I find a bottle o'rum?
reference: whrl.pl/RbiZ8q
posted 2007-Sep-19, 6pm AEST
User #30842 3892 posts
myobman
Whirlpool Forums Addict
I would be fixing it up. If it was too large, or had too many users (at 3 it hasnt) I would migrate to SQL server which is still free for smallish databases. If it was larger than allowed on SQL server Free edition then look at others - but not filemaker pro. Maybe the small version of Oracle.
To fix it up I might look at compacting it.
reference: whrl.pl/RbiZ9g
posted 2007-Sep-19, 6pm AEST
User #65104 1267 posts
Jones911
Whirlpool Enthusiast
myobman writes...
I would migrate to SQL server
I agree. SQL Server Express edition will have all the features you need if your upgrading from Access. I could be wrong but I think its limited to 1 million records per table though.
Edit: ts actually a maximum database size of 4 gig. Which is quite alot. Again comparing this to someone upgrading from access.
reference: whrl.pl/Rbi0rc
posted 2007-Sep-19, 8pm AEST
edited 2007-Sep-19, 8pm AEST
User #3462 4646 posts
_mathew_
Whirlpool Forums Addict
I suggest evaluating OpenOffice Base. It is a reasonably new player on the block, but is improving rapidly. The front end supports many different databases (including mysql), which means you can always use other tools to extract data for reporting / mail merge.
reference: whrl.pl/Rbi0AZ
posted 2007-Sep-19, 8pm AEST
edited 2007-Sep-19, 8pm AEST
images
images
No comments:
Post a Comment