Linked Views to SQLServer become Read-Only

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.

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.

Any Suggestions????

Thanks
Ray
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked Views to SQLServer become Read-Only 5
Sub projects added as read only in Master file which are saved on sharepoint 1
How to make linked tables to SQL Server views read only? 7
SQL Views linked to Access 0
Linked Excel File 3
Best way to deploy Access read-only database that is linked to SQL tables 6
Linked SQL Tables don't report Cascading Updates and Deletes 2
Conneting to SQL server, Need advice 4

Top