Set database to open as read only

  • Thread starter Thread starter Yvette
  • Start date Start date
Y

Yvette

Is there a way to default to a read only opening for a
single database, and then if the User know a password I
can re-open it within the program with more priveledges?

My client does not utilize User Group Security. They
have passwords to view this database but want for some
most people to just have read only priveledges. What is
the best way to do that? Do I have to secure each form
individually or is there some way to do that all at once?

Thanks.
 
You'll need to implement User Level security. I'm assuming you're using the
database password, which really doesn't allow you to differentiate between
different users. If you're using some other passwording scheme, you'll have
to let us know. Generally speaking, you'll provide privileges for each
object. ULS is no picnic; it trips up even experienced developers, so tread
carefully and do your testing on a COPY of your database. Download and
read-read-read the Access ULS FAQs
(http://support.microsoft.com/default.aspx?scid=/support/access/content/secf
aq.asp). Garry Robinson has a book out regarding Security (Real World
Microsoft Access Database Protection and Security) which takes you through
several different levels of security.

And yes,

--
Scott McDaniel
CS Computer Software
Visual Basic - Access - Sql Server - ASP

"Smash forehead on keyboard to continue ... "
 
You can implement user level security. You could apply read only
permissions to the Users Group and create groups/users for those with more
priveleges. The read only group wouldn't need to login, but the rest would.
 
Back
Top