Database Woes

[brainee28]

I have a problem.

My company currently uses these programs to do their daily work.

MS Access 2000
Dynamics 5.5
PSQL 2000
DOS based ERP System available via ODBC

I would like to explore a way for their data to be available to them via a Linux solution.

They are using Access as their front end to do accounting information.
Everything is stored in Access. (ick)

I'd like to either eliminate the use of Access completely, or to use it as a front-end to a solution that uses something like MySQL or PostgreSQL.

Any suggestions would be helpful.

Brian

[jsundquist]

Few questions need to be answered about the company first.

How large is the company?
How many people will be connected to the database at one time?
How will they be connecting to the database?
Are there any macros that are being used in Access?

Any other information that you can give us?

[brainee28]

Company is Medium Sized (150-200 employees)
Potentially 30 to 50 users needing access to this.
Connecting using XP or 2000 Pro machines(although this could be altered to Linux if Access and PSQL could be eliminated).

Most of the coding is done using straight VB code (no Expression Builder or Macros).

Accounting, Sales, Production, and Purchasing are the main parts to all this.

[ikellen]

If you knew a programming language such as PHP, you could write a whole system to interface with MySQL. PHPMyAdmin might work, but it's not exactly what you probably want.

[theN]

Hi

Look on www.sourceforge.net or www.freshmeat.net for accounting packages.

regards
theN