If during a VB6 migration you decide o take a step forward and move your databases to MS SQL
don't worry. The SQL Server team has a tool just for that.
I just don't know why it is so hard to find it in google. But the appropiate link is:
http://blogs.msdn.com/b/ssma/p/access.aspx
Also a recent article in Teched goes into all the gory details: http://technet.microsoft.com/en-us/magazine/hh334645.aspx
Good Luck and don't hesitate to contact us for any doubts.