Are you just transferring the data or the whole access application.

You will find the following Technet article helpful

For an indepth look at what is required to migrate an Access database to SQL Server, download Steve Koop's presentation (with added notes) from the Adelaide Dot Net User Group's...

Kathi/Steve,

Garbage in/Garbage out is always a possiblity, however 2sql statistics will help to identify problem objects.

If nothing else, 2sql provides a detail report on the status of the Access Database...

  I am Group Leader of the Adelaide Dot Net Users Group http://www.adnug.com based In Adelaide South Australia.