Web enabling Access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to take an existing Access database app and set it up with forms to add/edit data and reports to display/download data that are entirely accessed through a browser. From what I have been able to find, my options are to use Data Access Pages, and/or write my own ASP or php pages linked back to the mdb. Is there a way to make use of InfoPath to do all the forms? The intent is a fully web accessed app - no replication or distribution of front ends, back ends etc. I also would like to avoid writing all that code from scratch with ASP/php.

Current app stats - 15 tables, 12 forms, 6 reports. ~500,000 records, not very dynamic data, mostly view, lookup uses

Thanks

Mik
 
Mike Finger said:
I want to take an existing Access database app and set it up with forms to
Click to expand...
add/edit data and reports to display/download data that are entirely
accessed through a browser. From what I have been able to find, my options
are to use Data Access Pages, and/or write my own ASP or php pages linked
back to the mdb. Is there a way to make use of InfoPath to do all the
forms? The intent is a fully web accessed app - no replication or
distribution of front ends, back ends etc. I also would like to avoid
writing all that code from scratch with ASP/php.
Current app stats - 15 tables, 12 forms, 6 reports. ~500,000 records, not
Click to expand...
very dynamic data, mostly view, lookup uses.

Mike,

ASP is the preferable way to go. No question about it, it is a lot of work,
but the only real competitor to it is Terminal Server. InfoPath is only a
semi-option, it is extrememly slow compared to ASP. Data Access Pages are a
poor last choice. If you don't have too many users (< 20), and do have a
beefy server, I'd go with a Terminal Services. You can be up and running in
a day or 2. I've done that and it works great. I've also done ASP front ends
and I can tell you, they are much harder than Access/VBA forms, but they do
work just fine too.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top