Can Access handle this situation?

[Brian Smith]

Hopefully this is the right NG for this question. I asked in the Access
Internet NG but did not receive a response. If I should be asking about this
in a different NG I'd appreciate knowing which one. Anyway, here is what I'd
like to know about.

I'm looking into setting up an online survey that would have about 20
questions (some open-ended) and be filled out by anywhere from 20,000 to
100,000 people over a one-year period. Also, I would like to give a much
smaller group of people access to data that pertains to them. They would
also be able to access a report pertinent to them. Is this possible using
Access 2000 and without using ASP? The hosting service I use can handle the
traffic of such a site, etc. so that should not be an issue. Is Access 2003
considerably better than Access 2000 in doing web-based applications? If ASP
is needed, are there any websites that provide good code examples that are
well documented? Finally, if one saves forms, etc. as ASP pages in Access
how useful/useable are they? Does Access 2003 let you save reports as ASP
files?

Thanks.

Brian

 

[Rick Brandt]

Hopefully this is the right NG for this question. I asked in the
Access Internet NG but did not receive a response. If I should be
asking about this in a different NG I'd appreciate knowing which one.
Anyway, here is what I'd like to know about.

I'm looking into setting up an online survey that would have about 20
questions (some open-ended) and be filled out by anywhere from 20,000
to 100,000 people over a one-year period. Also, I would like to give
a much smaller group of people access to data that pertains to them.
They would also be able to access a report pertinent to them. Is this
possible using Access 2000 and without using ASP? The hosting service
I use can handle the traffic of such a site, etc. so that should not
be an issue. Is Access 2003 considerably better than Access 2000 in
doing web-based applications? If ASP is needed, are there any
websites that provide good code examples that are well documented?
Finally, if one saves forms, etc. as ASP pages in Access how
useful/useable are they? Does Access 2003 let you save reports as ASP
files?

An Access application cannot be run in a web browser. You can store the
DATA in an Access/Jet MDB file, but you need to use some kind of web
technology to do anything with it in a web page.

 

[Brian Smith]

An Access application cannot be run in a web browser. You can store the
DATA in an Access/Jet MDB file, but you need to use some kind of web
technology to do anything with it in a web page.

Yes, I know that. I should have been more precise in what I'm trying to
determine. What I want to know is if I use Access for the backend will it be
able to handle the scenario that I described above? Also, is Access 2003
considerably better than 2000 in generating ASP pages?

Thanks.

Brian

 

[Rick Brandt]

Yes, I know that. I should have been more precise in what I'm trying
to determine. What I want to know is if I use Access for the backend
will it be able to handle the scenario that I described above?

I have no idea. Since engines that can are available for little or no cost
I guess I would just use one of those and not worry about it. Wouldn't the
hosting service be the one to provide the information about what they will
and will not support?

Also,
is Access 2003 considerably better than 2000 in generating ASP pages?

If either one of them generate ASP pages at all it would be news to me.