Cursor Types

[David.Poundall]

Could someone please set me straight on cursor types I am going round in circles here.

I thought I was using adUseClient for Cursor Location but in fact it turns out I was using adUseServer. I have heard snippets that say that this latter cursor location has unreliable record count feedback. I have not found this to be the case.

However, I find that I have an Update speed on a record of about 100msecs per record. Which is unacceptable slow. So I have done a trawl of the dbase forum and found hints that adUseClient should be faster.

But In fact I find it is ten times slower ??????

Does anyone know what the fastest way of doing a record update is in MSAccess 2000 ? Also what should I be using for my Cursor Location, client or server.

Thanks in advance.

.