MS Access data conversion - upsize table and form to SQL Server with Identity Column

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

upsize table and form to SQL Server with Identity Column

bigoldcloser

2006-01-11, 8:25 pm

I have a very simple form that I use to enter data for a table. I upsized
the table to SQL Server and linked it. In some underlying code, when
I try to update a column in the table that the form is using as the source
I get the familiar, "need to use dbSeeChanges in OpenRecordSet for linked
SQL server table...."

My problem is that I think the form does the OpenRecordSet in the background
when the form is opened, so I don't know how to set the dbSeeChanges option.

This is what I'm doing:

strSQL = "update employee set employee_save_date = now() where emp_id =
Me.emp_id
CurrentDb.Execute strSQL, dbSeeChanges

This executes when I hit my save button I created on the form. The error
then pops up on the screen. Any ideas?

Thanks!

Bill Auslander

Sponsored Links