dbseechanges option with openrecordset 2

[lars7]

Hi,


Tried this on the server forum and they told me it was an access question.

This code worked fine until I uploaded the tables to the server.

Can anyone see why I am getting this error message:

"You must use the dbseechanges option with openrecordset when accessing a sql server table that has an identity collumn"

with this:

'strSQL = "UPDATE tblRecords SET tblRecords.HRAdviser = '" & [Forms]![FormMain].[Form]![FormSubMainRecords]![TextUserName] & "'" & _
'"WHERE tblRecords.HRAdviser Is Null AND tblRecords.RecId=" & [Forms]![FormMain].[Form]![FormSubMainRecords]![RecId]

'CurrentDb.Execute strSQL, dbFailOnError

 

[JoeAtWork]

I had to do the same thing when I upgraded to an SQL Server backend.

Just add the dbSeeChanges argument and it should be fine.

 

[lars7]

Hi Joe,

Thanks but how do I do that?

 

[Spenney]

Try...

CurrentDb.Execute strSQL, dbFailOnError + dbSeeChanges

 

[lars7]

Thanks Spenney,

That worked great.

 

[JoeAtWork]

Sometimes I wonder if people's F1 keys are permanently broken...

 

[lars7]

Hi Joe,

I looked up microsofts site and other forums but could not work out what you ment (this ones search was not available at the time) sometimes I can't see the woods for the trees but I can see now you deserved a star.