Moving .mdw file

[tminn]

I created a secure database on a server in one location, then it needed to be
moved to another, so I did that. Everything is working fine and as intended,
except that now users are unable to change their passwords. Upon attempting,
they get a message that says: Cannot update. Database or object is
read-only.

Is it possible that the mdw file locked somehow when it was copied? Or is
this for certain a network permissions issue (it shouldn't be, since users
can update the back end, etc.)?

Any thoughts are greatly appreciated.

 

[S Panja]

The mdw file gets locked under certain circumstances. If copied when locked,
the lock persists for a significantly long time - up to a week in my
experience. However, network privilege is more likely the issue : check out
if file create permission is enabled.
--
***************************
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?

 

[tminn]

Thanks for the reply. It turns out you were correct, it was a network
permission issue, not an issue with the .mdw file. It's solved now! Thanks
again