Hello,



i am working with Access forms, and on the form i am adding record in the sql server. Problem:

Sql query doesnt show all the values for the columns. My query has got 32 columns where as values it shows are up to 4-5 columns.
Is there any limit on ho wmany columns you could use in Sql through access? Am i missing something here?If i didnt make myself clear plz let me know and i will try again.
Below is the query in 'Add watch'. All fileds have values, but query is stopping randomely.


Code:
 
"INSERT INTO dbo_tb_qua_capability ( Ref_no,Received_date,Employee_number,Department_number,Ac_type,Description,Part_number,Throughput,ATA,Target_date,QIR_obs) values ('Q/C/09-9,'',2089,-1,'test,'test,'test,'test,'test','24/02/2010','test','test','24/