Hello All,
I have created a database application in MS Access 2002. I have upsized it's tables so that now they reside on a SQL server. My plans for deploying this application is on a Citrix server (Metaframe XPE). All my queries are Access pass-thru select queries. This will be a multiuser environment lets say maybe 200 concurrent users. I have record locks on form set to "no locks".
My question is:
Would I run into problems if all concurrent users ran queries at the same time?
If I had these MS Access queries converted to SQL queries or Views would that make a difference rather than using pass-thru queries?
Does MS Access have a limit to how many instances of an application can be ran concurrently?
What do you advise that I do in the case that my 200 concurrent users can't utilize my program?
Thanks,
E-force!
I have created a database application in MS Access 2002. I have upsized it's tables so that now they reside on a SQL server. My plans for deploying this application is on a Citrix server (Metaframe XPE). All my queries are Access pass-thru select queries. This will be a multiuser environment lets say maybe 200 concurrent users. I have record locks on form set to "no locks".
My question is:
Would I run into problems if all concurrent users ran queries at the same time?
If I had these MS Access queries converted to SQL queries or Views would that make a difference rather than using pass-thru queries?
Does MS Access have a limit to how many instances of an application can be ran concurrently?
What do you advise that I do in the case that my 200 concurrent users can't utilize my program?
Thanks,
E-force!