passwords for access 2007

[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.

 

[Gina Whipp]

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.

 

[Arvin Meyer [MVP]]

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.

 

[John W. Vinson]

how do i create username or group with passwords in .accdb.

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.