M
Mark A. Sam
I am having trouble with a linked SQL Table when I use an Update method
after an AddNew.
ODBC Call failed.
I tried it on a button to play with it.
Private Sub Command0_Click()
Dim dbs As Database
Dim rst As Recordset
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("Order Entry Technical Specs", dbOpenDynaset,
dbSeeChanges)
rst.Edit
rst![cpManuf] = "Test"
rst.Update
Set rst = Nothing
Set dbs = Nothing
DoCmd.Beep
End Sub
the above worked, without a problem,
rst.AddNew
rst![cpManuf] = "Test"
rst.Update
This worked once after I changed the Edit to AddNew but thereafter generated
the error.
I tried to reproduce what I did to get AddNew to work but couldn't.
The table opens fine and I can update it manaully without a problem. The
tables in the Db were all created using the Upsizing wizard in either A2000
or A2002. The App is a A2000 Db running in A2002.
Thanks for any help.
Mark A. Sam
after an AddNew.
ODBC Call failed.
I tried it on a button to play with it.
Private Sub Command0_Click()
Dim dbs As Database
Dim rst As Recordset
Set dbs = CurrentDb
Set rst = dbs.OpenRecordset("Order Entry Technical Specs", dbOpenDynaset,
dbSeeChanges)
rst.Edit
rst![cpManuf] = "Test"
rst.Update
Set rst = Nothing
Set dbs = Nothing
DoCmd.Beep
End Sub
the above worked, without a problem,
rst.AddNew
rst![cpManuf] = "Test"
rst.Update
This worked once after I changed the Edit to AddNew but thereafter generated
the error.
I tried to reproduce what I did to get AddNew to work but couldn't.
The table opens fine and I can update it manaully without a problem. The
tables in the Db were all created using the Upsizing wizard in either A2000
or A2002. The App is a A2000 Db running in A2002.
Thanks for any help.
Mark A. Sam