Skip to Content
Former Member
Aug 06, 2010 at 09:42 AM

How to change the Access for Database views


Hello Experts,

My requirement is to copy the records of a standard database view BDCPV (which is a combination of BDCP & BDCPS) to a custom view and then compare the records with a new table BDCP2.

I copied the BDCPV view to a table and used the custom view in the program. While executing the program, I'm getting an error message like "The database view <View Name> is write protected, so it cannot be changed".

I'm unable to change the Access under Maintenance Status Tab from Read only to "Read and Change". Could anyone help me how to resolve this issue".

Also please share teh sample code if you have any for the above requirement. We are using it in a SP upgrade to one of the systems.