If you are expecting to get thousands of hits per day, especially if they
are concentrated into a small time frame, Access is not a good choice for
web development. I have sites which get a few thousand hits per day, spread
out throughout the day which do just fine.
Stay simple, i.e. do not try to do too much on one form. Subforms are out,
they don't work in an asp environment. Typically, instead of a subform,
you'd just move to a new page and enter your data. Get yourself a book on
asp and build some asp forms to access your data. I use Front-Page and
Notepad to build my web. It's not very hard, but it is different than
working with Access forms.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access