ODBC Read Only

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
In VB, I tend to use the JET database directly rather than
via ODBC JET driver.

HTH
Van T. Dinh
MVP (Access)
 
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.
 
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.
 
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)
 
Back
Top