Oops sorry about the adOpenStatic-adLockReadOnly I'm looking at a different
recordset.

Thanks,

enzo c",)?
http://www.tropangwatakwatak.tk

-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: Monday, December 16, 2002 10:04 AM
To: sql language
Subject: [sql_language] Re: Cursor Types Issue


In answer to your first question:
You probably don't have an adOpenStatic cursor. See:
www.adopenstatic.com/faq/jetcursortype.asp for supported cursor/lock
combinations. If you use adLockOptimistic or adLockPessimistic, then you are
getting an adOpenKeyset cursor

In answer to your second question:
a) you don't have a # at the end of the WHERE criteria
b) what was the error message that you got?

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Enzo Zaragoza" <enzaux@g...>
Subject: [sql_language] Cursor Types Issue


:
:
: Hello!  I'm using ADO. VB6 front end and Access 2000. As far as I can
know:
:
: 1.) adOpenForwardOnly
: 2.) adOpenKeySet
:       - like dynamic but cant see additions, deletions, but can see
changes
: 3.) adOpenDynamic
:       - can see add, del, changes
: 4.) adOpenStatic
:       - add, del, changes cant be seen
:
: I've made some test I've tried using adOpenStatic on the recordset
: then I ran the vb form then I tried changing the record data directly on
: my back end db.  When I try to navigate on my vb form, it seems that I can
: see the changes I've made on the tables which should be not because the
opening
: of the form occured first before I updated the table.
:
: Am I correct with my conclusions?
:
: OT: How can I make a TimeStamp thing on Access?  Before i thought I could
: make use of
:
: "UPDATE table SET field1='data', TStamp=#12/13/2002# WHERE TStamp=#" &
origTStamp