After upsizing, you need to at least take llok at the tables in SQL Server,
did you?
The table must have at least one index t be updateable, while upsizing does
not transfer the index (usually it is primary key). So, you need to go to
tables design mode in Sql Server/MSDE and fixing those tables index/primary
key
Ned
You need a unique key to update a table, also it is a good
idea to include a timestamp column in your tables, this
column will get checked by to see if it has changed and
prevent re-reads of all of the data when you update.
An identity column is a very simple way to get a unique
key handled by sql server and not have to modify code if
you don't have a unique key already.
The upsize wizard should allow you to transfer indexes and
create timestamp fields when you upsize, you might want to
try upsizing a copy into a test database to try this.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
