Our company is currently using Access 2003 to connect over ODBC to a MySQL database. We chose Access 2003 because of its use of forms. More recently, we have been looking for a solution which might centralize our process.

Instead of having to maintain 5 workstations with Access installed, we’d like to move to a web based system. Does anyone have any ideas for an Access replacement which uses a similar interface on a centralized server? Thanks!

No. If you're not using Access as a database, you don't need to replace it. Html has a "form" tag, with text boxes and buttons, and all that great stuff. If your data is housed in MySQL, your web server is all you need.

You're far better off visiting the PHP forum - I'm assuming that's what you'll use. ASP.NET is a much better option, but if you're using MySQL, you probably have a LAMP server, so that forces you into using PHP. Anyway, you use that to make web forms, and you hook those forms up to the database, using web server code.