Hi,
I am using C# to write/read to an Access 2007 Database. The table is
ID - AutoNumber [pkey]
Fname - Text
Lname - Text
Address - Text
The query string I Use is
"Insert into TblMain (Fname,Lname,Address) Values ('"+fname+"','"+lname+"','"+adrs+"')"
No errors are returned, the query executes but data is not added to the db.
Inserting to table using which does not have an autonumber data column works perfectly.
What am I missing?