Updateable recordset from parameter query using Jet 4.0 provider

Updateable recordset from parameter query using Jet 4.0 provider

Post by Kevin » Sat, 17 Jan 2004 21:30:43


Is this possible?

Using the following VB6, ADO and Jet 4.0 provider

I'm trying to use an ADO Command object based on a parameter query to
provide a uniqe record for a form, using the unique record ID as a
parameter. Trying all combinations of cursor types and locking types, I get
the error this recordset is not updateable. I have searched the knowledge
base but cant find a difinitve answer.

Are all recordsets from a parameter query in Jet 4.0 non updateable?
If not what could i be doing wrong?
 
 
 

Updateable recordset from parameter query using Jet 4.0 provider

Post by Eugenio An » Sun, 18 Jan 2004 00:52:25

I've done it many times:
Scenario:
Microsoft Access 97 database
ADO 2.5, 2.6
Query: Select * from table1 where id=p1;
Cursor Location: aduseclient
Cursor Type: adusestatic
Locking: adlockoptimistic or adlockpesimistic

If you are opening connection via JET OLEDB Provider there are some
limitations, I recommend to use ODBC for Jet connections.

Eugenio



get