Re: Non GUI DB System

On Thu, 24 May 2006 jasmith@xxxxxxxxxxxx wrote:

I am working for a company that is currently using a Windows based (VB
to an Access backend). Needless to say, they hate it. They compalin
that it extremely slow. Also, the manager comes from the old AS/400
days and prefers a text based (Non Gui) system similar to they way the
AS/400 works.

My question is can you create this type of system on Linux with MYSQL
or something similar? What would you use as the front-end? What would
be the learning curve involved to program this type of system? Would
you get better performance?

Thanks



The nice thing about databases, you can normally always use different front-ends as long as you have a connection to the backend. With your current VB-Access solution, you could certainly implement the backend with mysql. Granted, it will likely be more robust as Access is more of a small-medium database solution.

But yeah, just about any other database system could replace Access...and mysql would be a fine choice.

As for a front-end, take your pick. You could rewrite the VB app to connect to mysql. You could make it web-based and write a frontend in PHP. Really, any type of programming front-end that has connection functions to databases would work, so it would really just be whatever you are most comfortable with.

As to the learning curve, depends on your background and programming experience. Depending on what the current VB front-end does and looks like, it could be several weeks before you can build the basic functionality. Several months if there are a lot of business rules.

Performance should be a lot better, as Access is not very efficient once you start adding large volumes of records or more than a couple users, especially if its over a network. Plus, if it hasn't been compacted and repaired recently, that can also negatively affect performance. mysql, or any major DBMS should deliver much better performance than Access.

Hopefully that gives you a start...

Dan
.

Relevant Pages

  • Re: pro- foreign key propaganda?
    ... I had built the DB backend using postgresql. ... reasons decided to switch to MySQL and created his own tables (as well as ... They'd also never leave foreign keys out of their designs, too, I guess. ...
    (comp.databases.theory)
  • RE: [PHP] Microsoft .NET arguement
    ... You can't interface MySQL with ODBC? ... I've found MS SQL (and MS Access databases) to be extremely fast ...
    (php.general)
  • Re: Zugriff auf ODBC-verknüpfte Tabelle in anderer MDB
    ... Von einem Access Frontend aus sollen nun per VBA Daten in diese ... mySQL Tabelle geschreiben werden. ... Das ganze klappt solange die Backend MDB auf dem gleichen Rechner ...
    (microsoft.public.de.access)
  • Re: Splitting a Microsoft DB
    ... > another directory on the same server. ... > keep the front-end on the server and any modifications ... copy and update when you've finished modifying the frontend and tested it. ... you'll end up with a secure frontend, but an unsecured backend. ...
    (microsoft.public.access.setupconfig)
  • Re: Linked Tables
    ... In the front-end, does the table show with/without a small arrow to the left ... > The "problem" that I discovered was that field definition of a particular ... > field in the backend and the frontend (also from Table ...
    (microsoft.public.access.tablesdbdesign)