Update stored procedure and Update Trigger ? Conflict

[LTusing]

I have an update trigger for a table and a VB command procedure which calls an update sql proc for editing of table fields.

I am receiving an error message when updating fields noting that database is not available. However, if I delete the update trigger, and then populate the update command the update will occur, although I still receive the same message, 'unable to open database'. I am not sure of what would cause this problem and requesting your input. Thank you!

 

[ESquared]

Instead of running your sql command from VB, print it to the debug window. Then use Query Analyzer to run the statement and see what results you get. If everything is okay, then back in VB, when the error occurs, look at not just the VB error object but also the ADO Connection.Errors collection, examining each ADO error. Often any errors past the first one are more informative.