what sort cursors are used in msacces?

nicetohaveyou

i have cooencted a access fron end with a sql backend. what sort cursors are used? Is it client side or server side?

Pete OHanlon

That depends entirely on your connection and the way you interact with it.

Deja View - the feeling that you've seen this post before.

astanton1978

None if you can help it. Cursors are sometimes a necessary evil (thier performance is not great and thier logic (procedural) is in conflict with the set based nature of SQL), but you should first try REAL hard to avoid using them. Not to steer you away from this wonderful site and its knowledgable participants, but you may get more specialized assistance with your question at a place like sqlservercentral.com.

Pete OHanlon

That's not what he's talking about. He's talking about a client-side versus a server-side cursor. This was more of an issue with old ADO code than ADO.NET.

Deja View - the feeling that you've seen this post before.

My blog | My articles