Very Computer

Howdy,

  I have a VB5 app which is accessing an SQL Server database through
linked tables in an Access 95 database. When I perform an INSERT using
an SQL statement (insert into tblArea values ('ns1010', 'area', 1)), I
always get the 'ODBC--Call failed' error. However, the values *do* get
inserted into the table on the server! I get the same error if I set the
statement to be a pass-through statement (dbSQLPassThrough).

Has anybody ever seen weirdness like this before? The table on the
server has three fields (I'm filling in all of them), two of those
fields make up the Primary Key.

Thanks in advance for any help,
Craig

Examine all the errors in the Errors collection and see if it gives you
more information.