S
Schrooms
We just did an upgrade from sql2000 to sql2005.
We tested all access based application and they seemed to work.
We also have a replication to an sql2000 server.
After we upgraded were getting unusual errors (error 3167 record deleted),
this error does not always occur .
Were using DOA record sets to access and change the data.
The error occurs when an 'adnew' and 'update' is given and were trying to
recover the new identity by using the 'MoveLast' member.
Example:
Dim rst As Recordset
Dim strSQL As String
Dim id as integer
strSQL ="select * from table where 1=0"
Set rst = CodeDb.OpenRecordset(strSQL, dbOpenDynaset, dbSeeChanges)
rst.AddNew
rst!field1 = "bla"
rst!field2 = "bla"
rst.update
rst.MoveLast
id = rst!id 'this is where the error is raised
We tested all access based application and they seemed to work.
We also have a replication to an sql2000 server.
After we upgraded were getting unusual errors (error 3167 record deleted),
this error does not always occur .
Were using DOA record sets to access and change the data.
The error occurs when an 'adnew' and 'update' is given and were trying to
recover the new identity by using the 'MoveLast' member.
Example:
Dim rst As Recordset
Dim strSQL As String
Dim id as integer
strSQL ="select * from table where 1=0"
Set rst = CodeDb.OpenRecordset(strSQL, dbOpenDynaset, dbSeeChanges)
rst.AddNew
rst!field1 = "bla"
rst!field2 = "bla"
rst.update
rst.MoveLast
id = rst!id 'this is where the error is raised