I've been working on an Access program that will have back end on SQL server. A few weeks ago i upsized a test version to SQL server, now I've changed the table structure quite a lot:
it's a 24 table database,
6 of which are new since the last upsize (but may contain data that was in other tables)
5 of which have had columns added / removed / transferred.

is there any way to upsize the new version and retain the data from the old one?

any help appreciated,
dave

Yikes.

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?


mmcdonal

Look it up at: http://wrox.books24x7.com