SQL table stuck on read only?

[kgarman]

First of all, thanks for the help/advice in advance.

The problem: I am trying to utilize a table in SQL. The table is stuck on "read only". We are not sure when/why/how this has happened, especially since this table has always been "read and write". If you have any advice on how to change a table in SQL from "read only" to "read and write" it would be of great help. Thanks.

 

[willir]

kgarman

...utilize a table in SQL...

Are talking about SQL as in MS*SQL or Oracle table?
Security can be set by the DBA with the administration tools. A common security "hole" that is plugged up is when users can update the tables via ODBC connection to the server. And the resolution to this is to ensure ODBC connection has only read-only access.

If you are talking about using SQL to review data in the Access tables, then the query may have resulted in non-updatable tables. Basically, the SQL engine has to know what specific record is being updated. (primary key, unique record)

Review this cool article for moreinfo...
Harnessing the Power of Updatable Queries (Microsoft)

Richard