hello,

i have some problems with inserting data into ms access database,

it gives me the same eror over and over again :

"insert into syntex eror".

after that

when i open the database its in "read only" state, and i cant change nothing in the datafield within the software,

other sql commands dont work as well.

please help me,

i cant insert,delete, upload. data.

what is the problem?

tnx mike

mikebraginsky:

it gives me the same eror over and over again :

"insert into syntex eror".

what is the problem?

The problem is that you have a syntax error in your INSERT statement.  You need to fix it.  Here's how: http://www.mikesdotnetting.com/Article/76/80040E14-MS-Access-Syntax-Error-messages

 no, it is still doesnt work

whats wrong with this one for exemple:

dim tt as new oledbcommand("delete from mikiliki where numinumi = 2", con)

tt.connection.open()

tt.executenonquery()

tt.connection.close()

 oh and by the way,

now it says:

cannot delete from database - failure

and when i insert it says:

you should use updatable query

mikebraginsky:

and when i insert it says:

you should use updatable query

http://www.mikesdotnetting.com/Article/74/Solving-the-Operation-Must-Use-An-Updateable-Query-error

thank you very much!

it worked!

thank you!