Interesting question. I'm not sure if such a tool exists, so I will explain how I would go about it without the aid of a third-party tool.
The main thing you should realize right off the bat is that Access gives you a lot of functionality with buttons and other controls and they are quite easy to control with macros and/or VBA. However, depending on the complexity of your forms, most of this functionality will be a challenge to replicate on the web, regardless of which language you choose. Therefore, you might be best off by starting a review of your current forms and their functionlity and evaluate their "critical need" level for your project. Second, you should design some of the forms within an HTML editor. This will help you get a feel for what controls you will need to re-create as well as buttons that you will have to add. Keep in mind that the buttons will have to be controlled with client scripting (ie JavaScript) so it wouldn't hurt to have a good JS reference handy. Finally, you can start to create the connections between your web-based GUI and the back-end. If you really want to re-create the Access functionality as much as possible, and you're not married to the idea of a PHP solution, you might want to consider using .NET. The .NET development environment is now form based, which will give you just about the same type of controls that you are used to within the Access development environment. If you're willing to invest in the server and software, an Access developer can feel quite comfortable with .NET. Good luck, Dennis ----- Original Message ----- From: "Apollo (Carmel Entertainment)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 09, 2003 10:53 PM Subject: I need advice. MSAccess frontend to PHP/MYSQL. ANyone done this? > I want to move my Microsoft Access based front end (back end is already on > MySQL/Linux) to PHP. MSAccess does have some forms that have VBscript in the, > but I think I can figure other ways to do that.I am not a wizard with PHP, so I > would interested in finding some open source apps, or something like that to > help me convert my front end to PHP/Apache/Mysql. GUI is what I am looking for. > Any advice? Anyone done this before? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
