The Access wizard has short comings (duh). Microsoft has a better migration tool at http://www.microsoft.com/sql/solutions/migration/access/default.mspx .