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
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.ssw.com.au SSW Upsize PRO! (97 and 2000)