VB5: Updating recordset on MS SQL-Server 6.5
I'm having the same problem useing Oracle. I found that if you create a
single primary key, then you are able to update/delete records. There is a
problem though, a duel primary key will lock the recordset from opening!?
Any way around this or is creating a single primary key a Jet limitation?
Thanks..
Quote:
> hi...
> i'm writing a client-/server-application with VB5 and
> MS SQL-Server 6.5. Database-access are via Jet and DAO.
> Everything works fine execpt one thing:
> I'm not able to update any recordset i opened...
> for example - see this pseudo-code
> Set db = myWorkspace.OpenDatabase("DSN")
> Set rs = db.OpenRecordset("SELECT * FROM tabKunden", _
> dbOpenDynaset,dbSQLPassThrough+dbSeeChanges)
> This recordset is not updateable - trying
> rs.update generates a runtime error.
> How can I get updateable recordsets?
> bye, david
