January 2, 2003 at 6:05 am
Does anybody know the maximum number of connections direct through odbc to sql server 2000. i have an access front end that connects to a sql server 2000 database. i have a version running over a wan with 16 user. i would like to know if this would handle 50 users successfully,
Because it is through ms access 97 the connections are direct and not snapshots
Thanks in advance
Mark
January 2, 2003 at 6:10 am
I forget the actual number but it is very high as for SQL. The things that matter most are connection and the hardware of the server itself. Plus the method of data access. Going to 50 in your case will probably work but will be slow in many cases and may run into locking issues if they access the tables directly. This is more to do with access than anything else. I personally suggest trying to get away from access and move to web or VB. If remain in access try using Forms with VBA to access the data instead of attaching to the tables.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply