Hi all, I am making an application which contains Access database. Database contains "User_Info" named table which has 4 columns (ID,Name, Designation,Scale) and "ID" is AutoNumber . Now I am getting a problem at inserting Data to User_Info table.I am passing 3 arguments (Name,Designation,Scale) , I am not passing the ID bcoz it is AutoNumber. How to insert this Data to table?? Please help Tnx

The OP was correct in his statement that he did not include the value for the ID field because it has a value of AutoNumber. If you do not explicitly provide a value for a field in an INSERT statement, the default value defined when the table was created is used; in this case autonumber. As Jim indicated, changing the field name is the only change required. I don't know who Bob is though

LabVIEW

Access DB insert Problem

Solved!

Author

Thank you...

Message 11 of 12

(257 Views)

Author

Thank You

Message 12 of 12

(257 Views)

LabVIEW

Access DB insert Problem

Re: Access DB insert Problem

Re: Access DB insert Problem