Linked Views to SQLServer become Read-Only

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

Access 2000 on WinXP-Pro sp2
SQL Server 2000 on Win2k3 sp??

Access Database has several views linked from the SQL Server ...
everything works fine.. Read/Write/Update/Delete etc....

The SQL Database Table the views are based on has fields added/removed
SQL Views are refreshed (execute sp_refresh <ViewName>)

Access Database has links refreshed

The view wll open - but is now read only.
Views are still Read/Write on SQL Server

If I delete the linked view in Access and add it back - it becomes
Read/Write again.


Any Suggestions????

Thanks
Ray
 
As and additional note:
The Linked TABLE was not affected and remains Read/Write
(This is actually the table the views are based on)

Only the linked views became read only.

Thanks
Ray
 
Is this for ADP or for ODBC linked tables/views? Did you add any unique
index recently to one of the tables or are you using an unique index instead
of a primary key?
 
ODBC Linked ...
And I'm not positive about whether the index.

There is a primary key on the SQL table, but I'm pretty sure the View
refresh was performed AFTER the key was added. (I'm not the one that
added it - so I can't be positive of the timing)..

Thanks
Ray
 
For ODBC linked tables and A2000, see if the following article can help:
http://support.microsoft.com/kb/q209123/

You should also post your question in the m.p.a.odbcclientsvr newsgroup -
providing all the details about your tables and the views - as this one here
is about ADP, not about ODBC linked tables. You won't find many peoples
knowledgeable about ODBC here.
 
Back
Top