To access data import is essentially, originally can't modify the data, I changed sqlserver2000 fields in a database table to allow null, and the original https://bbs.csdn.net/topics/397914337,
Now found that can be modified, but can not add data, leaders help to analyze the possible reasons, thank you!

CodePudding user response:

Open the query analyzer, direct input statements INSERT INTO the product (product_id, title) values (111222) can be inserted INTO the data

CodePudding user response:

Open the query analyzer, direct input statements INSERT INTO the product (product_id, title) values (111222) can be inserted INTO the data, can also be used in asp page INSERT statement inserts data, but the use of rs. Addnew unable to INSERT new data

CodePudding user response:

Resolved in rs. The open SQL, conn, 1, 3, and rs. Addnew between, insert a conn. CursorLocation=3, but heard that insert into than rs. Addnew efficiency is high,