I'm already using jet oledb 4.0 as the provider in the connection string. I haven't tried using a different data adapter though. I'll try that. Thanks

Sorry for the long text... I'm using a dataset for the link between my application and the MS Access database. The problem I have is with the Update function of the table adapter object. The code is really simple and it works very well except in one situation. Here's the code (generated by dragging from the data source to the windows form): this.tblRequestBindingSource.EndEdit(); this.tblRequestTableAdapter.Update(this.forms_Work_LogDataSet.tblRequest); The situation when it doesn't work is very specific and I've tried it on several test applications and it seems to be caused by the dataset. When I create a new record and save right away, everything is fine. Then, if I make a modification to the record and save again, an Concurrency Violation exception is thrown. It only happens on new records. I can save as many times as I wish on already existing records, but not on new records. Usually, Concurrency violation exception is due to the fact that more than one user is modifying the record, but in that case, only one user is modifying the information. It seems as if the first update didn't "EndEdit" even though it was clearly done if you look at my code. That's not good because when I call the update method of the table adapter, it's trying to update every changes made in that table of the dataset, meaning I can never save changes in the application data unless I restart the application because it's always throwing the exception. I read many things on bypassing concurrency violation exceptions, and for the dataset, it seemed pretty logical to just remove the "optimistic concurrency" option. It didn't work, because well, that's probably not even the reason why it's throwing that exception. I was wondering if this problem can be solved, without switching to a disconnected mode. I want a solution or a reason as to why we cannot insert a new record and save more than once without leaving the application. This problem can easily be reproduced by dragging a data source on a form and trying exactly what I wrote that isn't working fine. If someone has a solution for that, I'd really appreciate the help. BTW, I won't accept "Don't use datasets" as an answer unless there really isn't an other solutions...

Hi everyone, I've been trying to select (from the code) a specific cell in the DataGrid control to change it's value. Exemple: if [cell].text = "" then [cell].text = "0" I didn't actually find a way to do that. Can someone help me out? Thanks!

That's what I'm doing right now, but I don't want the DataMember to be a table but rather a query. Is there a way to to this? The reason I want to do that is because I need to do operations in the grid, but I really don't know how. That's why I did a Query in MSAcces, but I can't use it as a dataSource for the grid.

I want my dataGrid's DataSource to be a Query from my MSAccess Database, but I can only put a DataTable from a DataSet as the DataSource. Is there an other way that the DataSource can be linked with my Query? (...too many "data" in this question...) Thanks!

By changing only the connection string, the datasource of my grids will still be ok? I won't even need to change it? Well, thanks a lot!

I'm doing a project in VB.Net 2003 (I don't think the method and code would really change in Vb.Net 2005) and the client wants to be able to change the database location at any place on his computer. In VB.Net 2003, I'm using the data adapters with datasets, along with a connexion, but my problem is how can I connect the controls to the database and manipulate the data if the location is changed? It's all done with a few lines of code only. Should I forget this method and do it all in code, or maybe someone have a better solution for my problem? Thanks!

Can someone please help me filling a DataGrid without a DataSource. I'm used to work with a component called the True DBGrid made by ComponentOne for VB6, and it was a walk in the park to change the cells' value. Surely there's a way to modify the values without a source, right? Thanks in advance!