Access 2000 db Conversion to SQL

[connexion]

Hi,

I've got a fairly complex access 2000 database that's split into front and back ends.

There's 32 back end tables and a whole host of complex front end queries and forms. The whole thing's around 25,000 lines of code so not a 5 minute job to rebuild! (sorry but i just can't stop tweaking it!!)

I hate the idea of all that data moving across the network, and having to make the front end machines work so hard so I'd like to get the server doing it's fair share of work because it's got dual 3Ghz Xeon processors which aren't earning their keep! I was thinking about converting the mdb to SQL and although i could pay someone to do it for me, i do like to learn! (so when it breaks i'm not at anyone's mercy!!)

I assume there isn't an upsizing tool on the planet that will let me do this by clicking a button so can anyone point me in the right direction with regard to something decent that can automate as much as possible. PLUS a good source of information on the differentces between access and SQL so that i can start seeing how to accomplish with SQL what i'd do in Access?

Thanks,
Vince

 

[pono1]

Vince,

This book is excellent...

Access to SQL Server

Regards,
Tim

 

[connexion]

Thanks

Thanks Tim,

That one looks pretty good. I'll order that plus a couple of others that seem reasonable and with a bit of luck they'll get me out of trouble when i inevitably get into it!

Cheers,

Vince