Hi yea,
If I am using access as my back end, how many can access the Access database at once and query it, also how many records is it capable of handling.

Regards


Kenny

cant remeber the exact figures that microsoft gave out but they arent correct i can tell you that.

all depends on the load of query and how you have written your code to be honest. how good the host is blah blah blah.

but roughly 20+ users can crash an access db, although i did have a site once that handled much more than that.

i wouldnt worry about it unless your going to be expecting major traffic.

as for size of records it can handle, im sure microsoft would have the info available on that, i think it was in the region of 200mb or was it 2gb, cant remember. <img src=../images/dmxzone/forum/icon_smile_tongue.gif border=0 align=middle>

Regards,
Dave

[DWMX 2004]|[FlashMX 2004 Pro]|[Studio MX 2004]|[SQL]|[Access2000/2002]|[ASP/VBScript]|[XP-Pro]
If you like online gaming, please register @ www.nova-multigaming.com

Edited by - UltraDav on 20 Feb 2004 21:05:24

I think the microsoft figures are 2gig for database size and 255 simultaneous users.
I know I've had 70+ simultaneous users with no probs but like Dave said this will depend on many factors.

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

Dont let your db get bigger than 1 gb.....

I worked for a company that had a few dbs in that region and they started to crash after the 1gb mark.

The figures that MS give for connections do not speak about connection over odbc. This should not make any great difference but imagine that the connection over odbc will be opened and broken quickly so you should not have any major problems with a large no of users.

Hope the info helps.

Regards
Vince

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting