Convert Access to Web

[Gary Williams]

Hi All,

I have a client with an access database based desktop application, written for her some time ago for her business and client records. The number of records is quite large and she wants to convert this application to web based. The application has a number of forms and reports as well as the straight database. I could just convert the access dB to MySQL and recreate the forms and reports in asp, but, to save time, is there an application anyone knows of that will convert the complete access application to web based?

Regards

Gary

[angst]

there are several apps to convert the db to mysql format, however I'm not aware of any apps to convert the access reports into another format.
google would be your best resource.

[demtron]

I have looked into Access-to-Web (ASP or ASP.Net) converts several times in the last 8 years. I have never found anything that would accomplish this. There are just way to many complex issues to make an automated process easy. For example:

- Access security
- conversion of VBA code
- file system permissions
- third-party component references
- error handling
- concurrency
- macros
- built-in support for linked tables and import/export specs

My take is that there isn't enough of a market for a tool like this.

[Gary Williams]

Hi Demtron,

I suspected that. I've also tried before to find such an elusive piece of software without success. I warned the client this may be the case so it's time to start coding this application for the net.

Thanks for your help.

Regards

Gary