I'm using MS Access 2003.
I'm wanting to switch my Back-End from MS Access to SQL Server Express. Just not sure the best way to approach this.
I've read that pass-thru queries to a SQL Server back-end can be very inefficient (sending the entire table of data over the network), so I'm wondering whether anyone has recommendations. Do everything through stored procs in SQL Server?
Is it a good idea to use DAO with an ODBC connection? Is there a better way?
Bottom line: My question is that for those of you who have done this effectively, what is your approach?
Thanks for any help you can give.
Wayne
I'm wanting to switch my Back-End from MS Access to SQL Server Express. Just not sure the best way to approach this.
I've read that pass-thru queries to a SQL Server back-end can be very inefficient (sending the entire table of data over the network), so I'm wondering whether anyone has recommendations. Do everything through stored procs in SQL Server?
Is it a good idea to use DAO with an ODBC connection? Is there a better way?
Bottom line: My question is that for those of you who have done this effectively, what is your approach?
Thanks for any help you can give.
Wayne