ADO Recordset Update

Hi,
I've got a problem to use Update to modify a record in a SQL Server table. The
methode triggers a access violation message like this:
First-chance exception in PIMDBM.exe (KERNEL32.DLL): 0xE06D7363: Microsoft C++ Exception.
Error:80004005.
ErrorMessage:Unspecified error.
Source:Microsoft OLE DB Provider for ODBC Drivers.
Description:[Microsoft][ODBC SQL Server Driver]Syntax error or access violation.

I'm using VC++6.0, ADO 2.0 and SQL Server 6.5.

If someone can help me. Many thanks in advance.

[Shahzad]

It is very difficult to help from what you have given. If you can give portion of your concerned code, it will be easy to answer.
general tips are:
chech if you haven't closed the table before you apply update()