Unanswered: Problem with setting database password
Good Morning All,
I am trying to set the database password to an Access 2000 splitted database. I have opened the database exclusively and try to set the database password, like from the Open Dialog Box, clicked the arrow to the right of the Open button and then choose the 'Open Exclusive' option, but it is still giving me the error as,
"You need to have the database open for exclusive use to set or unset the database password.....".
And also made sure that no one else is using the database. Any idea, why I am getting this error?
Resolved the issue, by setting the Tool...Options...Advanced tab.
"Default Open Mode' property set to "Shared".
Then tried to open the database exclusively,and set the password. The database password was set without giving any errors.