Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rjolivie
Starting Member
2 Posts |
 Posted - 2007-07-05 : 12:17:27
|
| I have created a SQL Server Database and connected it to an MS Access front end using an ODBC datasource connection.All reports and queries are in Access and I think that because the queries are in Access and not on the SQL that all data is being transferred across the network and that the data is actually being processed on the client-side. (It's getting slower as more data is entered).How can I link a SQL Server query through my ODBC connection so that the query is being processed on the server and only the results are being sent across the network?Thanks in advance for any advice.Ryan |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-05 : 12:41:28
|
| You can write stored procedures on sql server and caal them from frontend. By the way, how often do you rebuild index or update statistics? |
 |
|
|
rjolivie
Starting Member
2 Posts |
Posted - 2007-07-05 : 13:30:09
|
| I'm pretty new at this... I've never rebuilt indexes or run statistics.Should I? What is the purpose of those functions and how would I execute them?Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-05 : 16:26:42
|
| Yes you should, check books online for details. |
|
|
|
|
|
|
SQL, Access and ODBC