Problem using OLEDB provider for Jet 3.51
Aaron,
You are right, Keyset is the only allowed cursor type. However, surfing the
MSDN library I found that the problem I was experiencing was actually a
known-bug. I was consistently getting an 'Errors Occurred' error when
trying to update the value of fields. Microsoft's recommendation is to
insert a On error resume Next command...Sloppy workaround but it works.
Quote:
>David check your cursor type and location. I seem to remember that OLEDB
>Jet will only support "Keyset" cursor with client side cursor types.
>Aaron Allen
>>I am experiencing a series of problems trying to use the OLEDB provider
for
>Jet. 3.51 against an Access 97 database.
