Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post May 29, 2012 01:12 AM by Decker Dong - MSFT
Member
75 Points
178 Posts
May 27, 2012 10:44 AM|LINK
Hi,
Whenever I open my access database file, it was open but it is all the time read only.
I need to fix my access database file but cant change anything coz of read only.
I have tested with all the link advice from google but cant change read only.
Please, can anyone give me any advice or link to change the read only for access database.
Thanks in advanced.
All-Star
134966 Points
15422 Posts
ASPInsiders
Moderator
MVP
May 27, 2012 01:42 PM|LINK
make sure you've given the account your pages run under (Network Service or ASPNET) read/write permission to the db.
http://www.mikesdotnetting.com/Article/74/Solving-the-Operation-Must-Use-An-Updateable-Query-error
35986 Points
6550 Posts
May 28, 2012 01:05 AM|LINK
mbanavige read/write permission to the db.
It should be MODIFY permissions to the folder (because the ldb file needs to be created and deleted in that folder), as explained in the article....
118619 Points
18779 Posts
May 29, 2012 01:12 AM|LINK
Junior1012 Junior1012
Hello：）
Besides the two kind men said above，plz check whether there's a something like thread or some program that makes your file in use——Especially check whether your OleDbConnection is Closed or not……
Junior1012
Member
75 Points
178 Posts
Access database is read only whenever I open file
May 27, 2012 10:44 AM|LINK
Hi,
Whenever I open my access database file, it was open but it is all the time read only.
I need to fix my access database file but cant change anything coz of read only.
I have tested with all the link advice from google but cant change read only.
Please, can anyone give me any advice or link to change the read only for access database.
Thanks in advanced.
mbanavige
All-Star
134966 Points
15422 Posts
ASPInsiders
Moderator
MVP
Re: Access database is read only whenever I open file
May 27, 2012 01:42 PM|LINK
make sure you've given the account your pages run under (Network Service or ASPNET) read/write permission to the db.
http://www.mikesdotnetting.com/Article/74/Solving-the-Operation-Must-Use-An-Updateable-Query-error
hans_v
All-Star
35986 Points
6550 Posts
Re: Access database is read only whenever I open file
May 28, 2012 01:05 AM|LINK
It should be MODIFY permissions to the folder (because the ldb file needs to be created and deleted in that folder), as explained in the article....
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: Access database is read only whenever I open file
May 29, 2012 01:12 AM|LINK
Hello：）
Besides the two kind men said above，plz check whether there's a something like thread or some program that makes your file in use——Especially check whether your OleDbConnection is Closed or not……