passwords for access 2007

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

"Christine" wrote in message
...
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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Christine" wrote in message
...
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.

On Wed, 3 Feb 2010 12:24:09 -0800, Christine
wrote:

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

John W. Vinson [MVP]