Thanks!  Sorry for posting here because I thought this is somehow related.
I've tried posting this on other forums but no opinions were given.

	But anyway, thanks for the opinion, all I need is the opinion to help me
decide on which way should I use.

Thanks,

enzo c",)
PS
just wondering why did you
named your site "adopenstatic"

-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Wednesday, March 05, 2003 9:46 AM
To: sql language
Subject: [sql_language] Re: Requery or adOpenKeyset


adOpenKeyset is a lighter recordset (since only the PK values are initially
assembled).
Using requery and adOpenStatic would reassemble the *entire* recordset
everytime you called it.

Also, this is an SQL Language list, and your question has nothing to do with
SQL per se.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Enzo Zaragoza" <enzaux@g...>
Subject: [sql_language] Requery or adOpenKeyset


: Using VB6(FE), Ms Access(BE), ADO 2.5
:
: I have this form that shows data one record per page using a customize
record
: navigation bar(usually it contains 100 records). What I want to happen is
that I want
: to see the changes or updates on the table made by other users or by
myself. I want
: to ask your opinion on which way would be better to accomplish this,
:
: a.) use an adOpenStatic cursor (can't see changes and addition & can go
any direction)
:     but must execute a Requery after making updates.
: b.) or use adOpenKeyset cursor to avoid the Requery method.
:
: Any tips and suggestions would be greatly appreciated

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~