CODEWITHSUNDEEP
databasevb.netms-access
Rohit Shinde
Rohit Shinde

Reputation: 1603

MS access database in VB.NET

I followed a tutorial on the internet to create my own database. I succesfully built a program upon it. Then I created an access .mdb file(another database) and then I just changed the database which the program connected to, to the one which I created.

I just made that one change. But then it started showing me error whenever I tried to update using 

da.update(ds,"Phone Book")

where da is data adapter and ds is data set.

The error was: " syntax error in INSERT INTO statement"

I have just changed the DB that the program is connecting to. I did not change the code one bit.

EDIT: I forgot to mention, I searched for this on google, and one thing which I read was, that access database might be only read only or something. But I unchecked the read only box, so I don't know whether it still might be the problem. Although, I don't think there is a problem with the code

EDIT: I just discovered now, that even if I change the table which is being referred to, it throws up the same error.

Upvotes: 0

Views: 528

Answers (1)

Joel Coehoorn
Joel Coehoorn

Reputation: 415735

It sounds like the first database probably used something like Sql Server Express. That's a completely different kind of database then Access, with a different providers, different dialect of SQL, connection string, etc. Why would you think you can change all that without breaking some of your code?

Upvotes: 1

Related Questions