insert into access

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have asp.net web app (C#) where i'm trying to insert data into a table and
i'm gettng the following error. I'm not updating anything i'm trying to
insert via my SQL.

I'm getting an error now telling me the quuery needs to be updateable. all
the values are being passed correclty.
what am i missing to get this working?

here is my SQL
string addSQL = ("INSERT INTO carBuilder(empID, startTIme, EndTime, Make,
Model, notes) " +
"VALUES(" + "'" + empID + "', " + "'" + startTime.Text + "', " + "'"
+EndTime.Text + "', " + "'" + Make.Text + "', " + "'" +
ddModel.SelectedItem.Text + "', " + "'" + Notes.Text + "')");
 
Yeah Mike,
Its a permission issue!
Make sure the folder(where ur file .mdb)MC Access database file is under and
the file has Write and Read rights!!
It must have WRITE ACCESS..
Enjoy Patrick
 
Back
Top