I am trying to update a SQL Server table through VBA coding which keeps erroring. Ihave created a test example of coding that is being used:
Dim DB As Database, stSQL As String, RS As Recordset
Set DB = CurrentDb()
stSQL = "Select * From tblName;"
Set RS = DB.OpenRecordset(stSQL)
RS("[Name1]") = Me![Text1]
RS("[Name2]") = Me![Text3]
RS("[Name3]") = Me![Text5]
I receive the error
"You must use the dbSeeChanges option with OpenRecorset when accessing a SQL Server table that has a IDENTITY column."
With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®.
Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…