The col22 is in dataset table2 not in table1.Table2 and table1 have a relationship.

in VB.net 2005 I have problems when i try to insert new record in Access database with Update method.The record has a field Autonumber.And after inserting , in dataset the value of this field is 0, in database is ok.

thank you i try but the problem is the same. ( i'm using DataAdapter update method) The problem is only when i add new record and after i try to modify or delete the new record. if i close the form after adding new record and open again and try to modify or delete the record everything is ok. only my program is accessing the database , and there is no virus on my computer. -- modified at 10:12 Friday 10th August, 2007

I have a problem with my application.I have created a connection with an Access database using wizard.and i have a form with some buttons to add , delete and modify records.Bu some time ( !! Not always ) an error is generated : --Concurrency violation the update command affected o of the expected 1 records--. I can do many operations add , delete , update ..etc and everything is ok , some time i get this error. Please help me ! Modified : I found that the error is generated always if i add a record and then i try to deleted. ( but the error is generated in other situations too, but not always) -- modified at 21:03 Thursday 9th August, 2007

Same problem : My.Settings.MyConnectionString = str My.Settings.Save() Error "Property MyconnectionString is readonly"

The same message "ConnectionString propert is readonly"

i get an error : Property is readonly

Thank you The databases are on different computers , later we can add new databases on other computers , the location of databases may change so is not possible to create multiple connectionstrings. I like the idea to create a form where user to select the database and then to create the connection string. But , how to create and store the connection string in the settings file ? Can you give me some code to do this ? Thank you !

I have this problem :I have developped a application in vb.net.This application use a microsoft Access database.I have used data wizard to create the connection , dataset , etc.But now there is a problem in our company : There are several Access Databases on some network computers and we want to work with these databases on my application.All the databases are identical . Now how can modify my application to make possible for users to choose one of this databases and to work with it. I don't knoth if is possible to change the connection string ? Or there is another way ? Thank you in advance !