Accessing Btrieve using ODBCDirect

[jbrowne]

Hi,
I am trying to access a Btrieve database using ODBCDirect. I have used the folllowing code to do this;

Set wrkODBC = CreateWorkspace("ODBCWorkspace", "", "", dbUseODBC)

Set sysdb = wrkODBC.OpenConnection("Connect1", dbDriverNoPrompt,False,"ODBC;DSN=ODSYSTEM;&quot

Set sImmsg = sysdb.OpenRecordset ("Immsg", dbOpenDynamic)

Immsg is the table that I want to open for read/write access.
My problem is that no matter what I do I can only open it as read only. I am using a Pervasive ODBC Engine Interface Driver.
Can anyone tell me what I’m doing wrong
Thanks in advance

John B
[sig][/sig]