by We start with a solid DSN Connection to a linked SQL
table. From the Access table we update 2 fields in
either the SQL table or a View of it. We can continue
with more successful updates as long as the database is
open.
When we close the Access database, then open it again and
try to do the update, we get Permissions Error 229. All
permissions are very good - the error happens at even the
highest level.
Workaround code with tabledefs and refreshlinks also
causes the error to happen if we run it.
I notice that the table appears to still be linked, but
it has been made unupdateable (read-only), where it
definitely was read-write when things work correctly.
When we go back into the database (the error not having
occured) and immediately relink with Tools, Linked Table
Manager before attempting the update, the update will
work.
Once the error has happened, however, the only recovery
is to redo the DSN with the ODBC Administrator.
Can someone help with a suggestion on how to stay linked,
or about what might be happening?
Thanks much in advance.
Jerry OC