By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,459 Members | 1,195 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,459 IT Pros & Developers. It's quick & easy.

Access2000 database on the internet

P: n/a
I want to use an Access 2000 database to power my .ASP web pages. Typical
example would be somebody filling in a form on the web page and saving it to
the database when they click a 'Submit' button. There is also readonly
stuff like list pages and search results which of course get their content
from SQL queries.

Now, I'm expecting at most 10 simultaneous users. But will my Access
database cope if it goes any higher? What if 100 people use the site at
the same time? Will the database say "game over", or can it cope?

thanks,
Owen
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On Wed, 14 Jul 2004 15:55:48 GMT, "owen" <sp**@spam.com> wrote:
I want to use an Access 2000 database to power my .ASP web pages. Typical
example would be somebody filling in a form on the web page and saving it to
the database when they click a 'Submit' button. There is also readonly
stuff like list pages and search results which of course get their content
from SQL queries.

Now, I'm expecting at most 10 simultaneous users. But will my Access
database cope if it goes any higher? What if 100 people use the site at
the same time? Will the database say "game over", or can it cope?

thanks,
Owen

That doesn't sound problematic, assuming reasonably well coded ASP
pages. For some interesting reads check out...

http://www.15seconds.com/Issue/010514.htm

Links to the library mentioned...

http://www.learnasp.com/learn/rsfast-intro.asp

http://www.learnasp.com/learn/rsfast-lib.asp

- Jim

Nov 13 '05 #2

P: n/a

"Jim Allensworth" <ji****@datacentricsolutions.com> wrote in message
news:40***************@news.west.earthlink.net...
On Wed, 14 Jul 2004 15:55:48 GMT, "owen" <sp**@spam.com> wrote:

That doesn't sound problematic, assuming reasonably well coded ASP
pages. For some interesting reads check out...

http://www.15seconds.com/Issue/010514.htm

Excellent, very interesting reading there.... thanks!

Owen
Nov 13 '05 #3

P: n/a
Well Response.Buffer = True would help.

Buffer That Output by Charles Carroll
http://www.learnasp.com/advice/whybuffer.asp

If you do more reading than writing, that would help.

Other than that the big thing that would probably happen before any kind of
"crash" (hopefully) would just be that the pages get unbearably slow.

Best regards,
J. Paul Schmidt, Freelance Access and ASP Web Developer
www.Bullschmidt.com
Classic ASP Design Tips, ASP Web Database Demo, ASP Bar Chart Tool...
Nov 13 '05 #4

P: n/a
<<
I want to use an Access 2000 database to power my .ASP web pages. Typical
example would be somebody filling in a form on the web page and saving it to
the database when they click a 'Submit' button.


Here is something I put together about ASP that hopefully might help somehow.

Web Database Concept
http://www.bullschmidt.com/concept.asp

You and others can have access to a database hosted on the Web from any
location that has a browser with an Internet connection.

The Web database concept makes sense if you and your people want to do work in
various locations in or outside the office and still be "plugged" in.

For example you could have employees enter timesheets or have sales reps log
their contacts. Or perhaps you'd like customers to be able to check the status
of their orders online without having to call the company.

If you want a Web database, typically what would happen is that a database such
as Access or MySQL (basically just consisting of tables) would be put on the
Web.

Then "dynamic" Web pages (such as classic ASP pages which include VBScript,
HTML, and/or JavaScript) would be created acting like the old desktop
database's queries, forms, and reports to access the database - all hosted on a
Web Server.

Dynamic Web pages are similar in many ways to regular HTML pages. But they are
"live" because the user can read from and write to information in the database.
An example where you can login and add, edit, or view fictional customers and
invoices is at http://www.bullschmidt.com/login.asp

Not all Web hosts will handle dynamic Web pages but many do. The Web hosts
that can handle ASP pages usually have a Windows 2000 or Windows 2003 operating
system running an IIS Web server.

Here are a few good ASP sites:
o ASP101 Samples - http://www.asp101.com/samples
o W3Schools ASP Tutorial - http://www.w3schools.com/asp
o Microsoft VBScript Language Reference -
http://msdn.microsoft.com/scripting/...BScript/doc/vb
scripttoc.htm

And the following newsgroup is good:
microsoft.public.inetserver.asp.general

Or for a "quick and dirty" generic ASP open source solution to putting
databases on the Web (often works well for the admin area of a Web site) that
just requires setting up a configuration page for each table or query and
uploading the database to the Web as long as there is an autonumber field in
each table (and you'll probably also separately want to create login
capabilities), perhaps try something like this:
GenericDB by Eli Robillard
http://www.genericdb.com and then click on the Tips link to see an example

Best regards,
J. Paul Schmidt, Freelance Access and ASP Web Developer
www.Bullschmidt.com
Classic ASP Design Tips, ASP Web Database Demo, ASP Bar Chart Tool...
Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.