A. To start with use the free Access upsizing wizard on MS's website. It works from Access 97 to SQL 6.5 or 7.0. It is available at http://www.microsoft.com/AccessDev/ProdInfo/AUT97dat.htm 

If you are using Access 2000 then the Access Upsizing tool that ships as part of Office 2000 only supports SQL 7.0.

There are also some 3rd party-products :-

http://www.weirperf.com
http://www.ssw.com.au SSW Upsize PRO! (97 and 2000)