Upsize backend from Access to SQL Server? (1 Viewer)

[geralf]

Hi

I am looking to upsize a Access BE database to SQL Server. The FE database will still be MS Access. I would like to keep the FE as it is and use an ODBC connection to the SQL BE database. My problem today is that I need better performance since we are using the database over a WLAN connection. As I understand it, Access sends the entire dataset/table across the connection whilst SQL Server only returns the requested data.

Is there anyone familiar with SQL Server that can guide me in the right direction here. Any insights are most welcome and appreciated.

TWe aare using computers with WinXP, server running Windows 2003 Server

hanks in advance

 

[wazz]

you won't like this, but...there are tons of posts about this already (probably why no response yet).

search for: upsizing, SQL Server, querydefs, FE, BE and combinations of these.