ODBC Read Only

[Guest]

Hello,
I have ODBC connection to a database in Access 2000, when
I use UPDATE statement in visual basic code and I get the
following message: "Cannot update. Database or object is
read-only. (Error 3027)". I tried to modify table
manually, it did not work either. Is it something coming
from ODBC definition? How can I define it so that I can
write to table.
Thanks,
Jim.

 

[Van T. Dinh]

In VB, I tend to use the JET database directly rather than
via ODBC JET driver.

HTH
Van T. Dinh
MVP (Access)

 

[JIM.H.]

It is not Access database that I access through ODBC, it
is a proprietary database.

 

[Douglas J. Steele]

Is there a primary key or unique index defined on the table? If not, I don't
believe ODBC will let you write to it.

 

[JIM.H.]

Oh ok. I can not change that table, it is used by another
application, is there any other way other than ODBC. It is
a foxpro table and I need to update one field with an
external nightly task.

 

[Douglas J. Steele]

Sorry, I don't know. A quick search of MSDN didn't turn up anything useful.

You could try posting to one of the Foxpro groups (they start
microsoft.public.fox)