passwords for access 2007

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

how do i create username or group with passwords in .accdb. I need some form
information protected from some users. I would like to have a checkbox on
the main form to allow the other users to access the infomation. Is the
possible, getting very confused with the process.
 
Christine,

Are you talking about creatig your own? Because ULS was removed from .ACCDB
format.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

how do i create username or group with passwords in .accdb. I need some form
information protected from some users. I would like to have a checkbox on
the main form to allow the other users to access the infomation. Is the
possible, getting very confused with the process.
 
You can't really do that anymore with the new format. There are a number of
other choices though to create your own security. Most are not enforceable
by Access. I have used the Windows Username to check whether there are
permissions to open a form, or to view data in a query.

http://www.mvps.org/access/api/api0008.htm

But you can't really do that with a table. Your best bet for that is to
totally hide the Navigation Pane.
 
how do i create username or group with passwords in .accdb.
Click to expand...

You can't. Microsoft removed user level security as a feature of the new
..accdb database format. It's still available in the older .mdb format under
2007.
 
Back
Top