Read Only removed by Password

[Ron A.]

Is it possible to have a database opened as read only and then using a
password to remove it from read only status? Thanks.

 

[Chris O'C via AccessMonster.com]

Which type of read only file opening are you using? File permissions or the
/ro switch?

Chris

 

[Ron A.]

I have not done either one. Please forgive me, I have limited knowledge to
Macros and VBA. Would it be possible to have a database open in read-only by
default and have a command button avalible to the user that when clicked
would ask for a password and then remove read-only when the password is
entered correctly? Thanks.

 

[Chris O'C via AccessMonster.com]

"Would it be possible to have a database open in read-only by default and
have a command button avalible to the user that when clicked would ask for a
password and then remove read-only when the password is entered correctly?"

Sorry, it doesn't work like that. The read only status is assigned when the
db is opened. It can't be changed after it's already opened. So you need to
control how it's opened.

You can open the db with the /ro switch for read only mode. Have a button
for the user to get prompted for a password. If the password is correct, the
db closes and opens without the /ro switch.

This is very easy to bypass for users with even a little pc experience. It's
simple but not recommended.

An alternative is to set up 2 sets of linked tables to SQL Server. The
default is to link to tables with read only permssions, but after
successfully entering a password, the read only linked tables would be
switched to links to the same tables as a user with read/write permissions.

Chris