I would pull the data from the SQL Server into your Access development database, then delete the old database (do a back up into a new access database using DTS) and then re-upsize the Access development database.
IOW, make sure the data works together in your dev environment first, then re-upsize and forget the entire old SQL Server database.
Alternatively, pull the data down to your Access dev database, and upsize it to a new SQL Server database.
Did that help?
Look it up at: http://wrox.books24x7.com