Why a Read Only Table?

[VBAmateur]

When I try to addnew and update to a particular table I get a return message saying the table or db is read-only and it will not allow edit or addnews. I know the db is not read only so what other things should I look for to get this to update??

[damonous]

First, make sure the table isn't already open in another location before you try to update it. When you open a second copy of a database, depending on how it is setup, it will be opened as "Read-Only" and you can't make any changes.

Next, when you open the database, be sure you are not opening it as "Read-Only".

Not "adodc.Recordset.Open Source, ActiveConnection, adOpenStatic, adLockReadOnly"

But "adodc.Recordset.Open Source, ActiveConnection, adOpenDynamic, adLockOptimistic"

These are the only two things I could come up with. Maybe something else?

[raicheman]

If damonous suggestions don't work....
I sometimes got that error when I was trying to add a record to an ODBC database when everything I could see was set up correct. The Database in question had over 10 indexes or primary keys and Jet could not recognize all of them. So, I either had to set a the primary key or indexes again or use something besides Jet to open and update that database.

Hope this helped