Problem linking Database

[hansnyc]

I'm using this code on a cmd button to confirm an order and at the same time take the order off my listbox which lists pending orders.

CurrentDb.Execute "UPDATE tblConfirmations SET ConfirmFlag = True Where JOBID =" & Forms!frmSwitchboardF.ListConfirm
Forms!frmSwitchboardF.ListConfirm.Requery

My problem is I'm trying to link this to my sql server and install it on multiple stations using an MDE file.

When I use that linked MDE file this code doesnt work

Same thing when I use the Main DBA linked to SQL Server

I get an error: "you must use dbseechanges option with openrecordset when accessing a SQL server table that has an IDENTITY column"

what does it mean? and how do I solve this?

 

[pbaldy]

It means exactly what it says. Here's an example:

CurrentDb.Execute "UPDATE tblReservationsWEB SET Status = 2 WHERE ResNum = " & Me.ResNum, dbSeeChanges

 

[hansnyc]

So what you are saying is that I should just add dbseechanges at the end of my statement?
I tried this but it doesnt work

CurrentDb.Execute "UPDATE tblConfirmations SET ConfirmFlag = True Where JOBID =" & Forms!frmSwitchboardF.ListConfirm
Forms!frmSwitchboardF.ListConfirm.Requery, dbseechanges

 

[pbaldy]

You have 2 separate statements there, not one, and you added it to the wrong one.

 

[hansnyc]

you're right!
Thanks a lot for the tip
And thanks for your time