Access to SQL Server

[doctorgonzo]

I will probably be moving an Access database to SQL Server in the not-too-distant future. Does anybody know of any good resources to assist me with the transition?

[HackinCowboy]

It's actually not very difficult. Micky$oft has a nice explanation of the process.

[doctorgonzo]

Thanks, I've got their white paper and everything, and I have looked it over. But what I am looking for is some information on making the code more efficient to take advantage of SQL Server's abilities. Dumping the data and so forth will be no problem; I would like some info on tweaking so that processing is done on the server and not on the desktop.