I have developed an application where the data resides on a Windows 2000 Terminal Server in SQL 2000. The front-end (Access 2000) will also reside on this same server. The main table in the database contains just over 300,000 records. I have done this for other applications where only five or six users connect simultaneously and it has worked flawlessly. My questions:
In this type of setup how many users do you estimate will be able to connect to this application without any problems from the Access front-end?
I'm testing different methods to access the server data and for the amount of records that I have, I find that my Linked ODBC tables and DAO is running just as fast as ADO and even faster than Acess Data Project (ADP) - any ideas on why this would be?
In this type of setup how many users do you estimate will be able to connect to this application without any problems from the Access front-end?
I'm testing different methods to access the server data and for the amount of records that I have, I find that my Linked ODBC tables and DAO is running just as fast as ADO and even faster than Acess Data Project (ADP) - any ideas on why this would be?
