how to connect my database access

[bantakiah]

i have computer A & B. in computer A i use be a server.
i have my vb program in computer A. i set my adodc connected to my access database using adodc.
in computer b i set my adodc to adodc in computer a but every i update data there a message error : operation must use an updatable query.
what must ido?

 

[RonRepp]

Post your code, especially where you get the error.

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

 

[bantakiah]

in adodc1.recordset.update. for adodc1.recordset. addnew is not problem. and if i set adodc conect to local database. example i put database in drive c in computer b and i connected. it working properly for adodc1.recordset.update

 

[BobRodes]

Well, you have to use an updatable query. The fact that you are going to a different server could well cause a query's default behavior to change from updatable to non-updatable. If you want to dig into this, perhaps you will find faq222-3670 helpful. In the end, it's easiest to use SQL update queries to accomplish this.

Now, to have a query remain updatable over a network places quite a burden on the network, and such a solution is not to be considered scalable in any sense.

HTH

Bob