I have been posting messages for a few days now but have still not been able to figure this out. When I try to write to a dbase table I have opened through ODBC I keep getting "cannot update. Database or object is read-only".

I know this is not true, and I am pretty sure that I have my ODBC connection set up properly. I have tried with DAO and ADO and niether works. Here is my DAO code.

Set wrkODBC = CreateWorkspace("", "admin", "",dbUseODBC)
wrkODBC.DefaultCursorDriver = dbUseODBCCursor

Set conPubs = wrkODBC.OpenConnection _ ("dBaseGeneric", , , "ODBC;DSN=dBaseGeneric")

Set rstTemp = conPubs.OpenRecordset("SELECT * FROM_ TBLDET",dbOpenDynamic)

This is my ADO code:

open the database and the tables
conPubs.ConnectionString = strDataSource
conPubs.Open
rstTemp.Open strOpenString, conPubs, adOpenKeyset,_ adLockOptimistic

If I use the exact same code with an Access table it works fine. So I think it has to do with either the ODBC driver itself, the way the ODBC connection is set up (I don't even see how you can make it read-only in there) or my dbase files (which are not set to read-only)