Our very small company (3 people) is planning
to develop an in house DB app for managing the
common business operations dealing with customers,
orders, inventory, etc.
Initially it will work on a single Windows PC.
However, in the future it might migrate to a
The main goal is to find some plataform that:
- is stable, does not crash all the time;
- easy to use, not requiring deep coding and/or learning;
- allows not only the managm. of tables and queries,
but also of forms and reports (or something similar);
- provides a good and flexible interface to the user;
- low plataform cost (free or under $100).
From what I've seen it appears that MS Access
is the most recomendable plataform in such a
situation. However, I would like to know about
other alternatives, namely:
* MySQL + Some Easy2Use GUI Client
Does it make sense use MySQL in such a situation?
Do you know of any similar examples that I can
We are running a e-business web site (www.plusdetudes.com) that offer a large number of market research and business report. We set-up this web site using MySQL/PHP as front office, and we manage a great number of operations thanks to our DB (oder, billing, content ...).
For our back office we use Access2K as a client, connected through an ODBC driver to MySQL, with linked table.
It is a realy great solution as Access developement is very easy (you can manage it whithout having to code a line) and can be handle by a person who dosn't know any code.
As your company grow, you can easy manage your apllication deployment, as it is client/server oriented. I think to begin with it's a great solution.