• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 258
  • Last Modified:

MS Access 2010 security so that more than one user can log in

Hi Experts

Im developing an access database, I only want two multiple users one for when Im developing and one for loging in.

Im using Access 2010, does anyone have any advice or a web link?
2 Solutions
If you are using the accdb file format then there is no longer any user-level control built in.

If you want different users to see/do different things you have to program it all yourself.

You can use the Current Database settings and the Navigation pane settings to hide objects but unless you use code to switch features on and off then it's the same interface for each user.

You can hold the Shift key to open the file for development and so by-pass all the settings and give you the out-of-the-box user interface.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:

  And just to be clear on one point, working within a DB in design mode requires exclusive Access.  You can't have anyone else in there while your making design changes.

  Was not sure from your question if this is what you were aiming for or more along the lines of what Peter was talking about.

MrDavidThornAuthor Commented:
thanks guys, live long and pork
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now