Same Code Access & SQL Server

[rhinoman]

I am writing a VB6 app that will be given away as a demo and will run using MS Ascess Db. Later if client decides to purchase, we will ship out MSDE or SQL Server.

My code below works with SQL 2000 but not MS Access 2000, no error is raised but data is not updated either. Must be a simple one but I cannot see it.

Thanks All, Graeme

params.Append objCommand.CreateParameter("@gst_inverse", adSmallInt, adParamInput, 0)
params.Append objCommand.CreateParameter("@letter_picture", adVarChar, adParamInput, 100)
.... continues.......
params("@company_name") = txtComp_name.EditValue
params("@abn") = txtABN.EditValue
params("@address_1") = "" & txtAddr1.EditValue
... continues .......    
objCommand.Execute , , adExecuteNoRecords
    
... runs and updates SQL server, runs in MS Access but does not update or return error.