• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • 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?
0
MrDavidThorn
Asked:
MrDavidThorn
2 Solutions
 
peter57rCommented:
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.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:

  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.

Jim.
0
 
MrDavidThornAuthor Commented:
thanks guys, live long and pork
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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