I copied all tables successfully except for one. This is the error message. Any ideas?
FORUM_SUBSCRIPTIONS
Insert Error. Column 1 ('SUBSCRIPTION_ID' DBTYPE_I4), status 10: Integrity violation, attempt to insert NULL data or data which violates constraints. Unspecified error.
Thanks ruirib. Before I saw that message, I created a new column with AutoNumber in Access and deleted the old column (it was empty) and kept the identity insert on and it upgraded successfully. This shouldn't cause a proble, should it?
No, it won't create a problem. My suggestion would just allow SQL Server to generate an identity value for each record inserted. You just made Access do it instead.
Topic Locked
Posted - 08 February 2005 : 18:48:45
