insert into access

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 + "')");
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,796
Messages
2,569,645
Members
45,362
Latest member
OrderTrimKetoBoost

Latest Threads

Top