Dear MS Access Expert,
Suppose I have a MDB that has ODBC links to SQL Server. All major tables are on SQL Server.
Suppose my backend is between 0.5 - 1 GB and the number of concurrent users is 50. Can I get good performance (assume good client / server design) if all queries are built using the Access query grid and stored in the MDB?
How good is Access at translating my Access Queries for SQL Server? Can I make all types of queries in Access (Select, Update, Totals, Union) for SQL server backend? (I know I can't use TRANSFORM.)
How much more effecient is executing Stored Procedures using ADO and bounding the resulting recordset to a form vs. bounding my forms to Access Queries.
What about bounding reports to pass-through queries? Is there a difference in performance between a pass-through query vs. a stored procedure in a read - only situation?
There seem to be alot of options when building Client / Server Access FE applications and I am trying to figure things out. Note: I have also looked at ADP and many people are suggesting to opt for MDB (ACCDB) using ODBC links to SQL Server.
Thanks
Peter.
Suppose I have a MDB that has ODBC links to SQL Server. All major tables are on SQL Server.
Suppose my backend is between 0.5 - 1 GB and the number of concurrent users is 50. Can I get good performance (assume good client / server design) if all queries are built using the Access query grid and stored in the MDB?
How good is Access at translating my Access Queries for SQL Server? Can I make all types of queries in Access (Select, Update, Totals, Union) for SQL server backend? (I know I can't use TRANSFORM.)
How much more effecient is executing Stored Procedures using ADO and bounding the resulting recordset to a form vs. bounding my forms to Access Queries.
What about bounding reports to pass-through queries? Is there a difference in performance between a pass-through query vs. a stored procedure in a read - only situation?
There seem to be alot of options when building Client / Server Access FE applications and I am trying to figure things out. Note: I have also looked at ADP and many people are suggesting to opt for MDB (ACCDB) using ODBC links to SQL Server.
Thanks
Peter.