RE: Access and the internet

06-15-2004, 13:59

Could be that you have two many connections (ie people connecting to the database) simueltaneously. If you have more than 20 that would slow things down. The only solution is to either to restrict the number of concurrent users in the ASP or upgrade to SQL Server.

----- Ken wrote: -----

I have a MS Access XP database running that I use the web (ASP pages) to
access.

However, lately I have noticed the system seems to get VERY slggish to the
point where it times out or I get "Too many Client tasks" error or even "Too
many users". We aren't a very big organization and we only have 20
employees, whom I doubt are all accessing the system at once. The database
is only 20 mb in size right now so nowhere near the maximum limit.

The techs say the server (windows 2000) is fine, our ISP says our connection
is fine. So now I'm at a loss as to what it could be - suggestions?

06-15-2004, 13:59	#1 (permalink)
chutney Civilians	RE: Access and the internet Could be that you have two many connections (ie people connecting to the database) simueltaneously. If you have more than 20 that would slow things down. The only solution is to either to restrict the number of concurrent users in the ASP or upgrade to SQL Server. ----- Ken wrote: ----- I have a MS Access XP database running that I use the web (ASP pages) to access. However, lately I have noticed the system seems to get VERY slggish to the point where it times out or I get "Too many Client tasks" error or even "Too many users". We aren't a very big organization and we only have 20 employees, whom I doubt are all accessing the system at once. The database is only 20 mb in size right now so nowhere near the maximum limit. The techs say the server (windows 2000) is fine, our ISP says our connection is fine. So now I'm at a loss as to what it could be - suggestions?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Access DB over internet	James Franklin	Web Design	1	04-29-2005 20:00
Internet access behind win xp sp2	John	Web Design	2	04-20-2005 12:00
Re: USA Internet Access	Andy Augustin	Web Design	1	02-03-2005 04:00
Re: USA Internet Access	Rick	Web Design	0	10-29-2004 20:00
Access DB on the Internet	Morris	Web Design	2	06-26-2004 07:35

Community Information
Options
	Contact Us - FAX - Terms of Service - Privacy Policy - Trackpads - Archive - Top
Trackpads Non-Commercial Ad

Time
	All times are GMT -4. The time now is 10:02.
Copyright
	The header is based off of work by Vipixel.com and modified by this site. Trackpads and the Trackpads Logo are both Registered Trademarks of Jason Edwards and cannot be used without prior written permission. The only exception is as a link back to this site. Trackpads is a private website run by a small legion of volunteers, 3 dogs, 12.5 cats and an army of small, super smart, bio-engineered mice with pointy hats and tutu's. Search Engine Friendly URLs by vBSEO 3.2.0 RC7
Archive Links
	1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70