Best Method , adUseServer Vs adUseClient

[barianto]

Hi,

I know this matter has been around and much debate along with it.

But please give me clear explaination why i should use one and why not the other one?

I'm using mysql Server 5.0.18

I will start first.

Using adUseServer my recordset objet will always update, even when data add/update by other user trough other application, as long it meet criteria recordset query, it will add/update the recordset. Problem is, it hog server resource.

Using adUseServer, share server load to client, but recordset not allways update. it will update only when we doing requery or refresh
For a moment there is difference between recordset on client application and "database source"

So what is best method to you guys?

[lok1234]

Same question here! But i am using Access Database!