I'm hoping someone can help me out with this. I think the answer is pretty straightfoward but I would rather ask first rather than end up corrupting live data.

I used the SQL Server Migration Assistant for Access to upsize an Access 2003 database to a SQL 2005 backend. The migration appeared to work OK, and I was able to put the new system in production. About a week later I was informed that about 5000 historical records were missing....