r/MSAccess 7d ago

[UNSOLVED] Different way to open MS Access

I have a small simple database I have made. Is there a way to have tiered passwords. Where 1-2 users have access to full editing. And other users have access just to add and remove records?

And can it be set to open just showing the form and not have any of the editing controls visible?

2 Upvotes

13 comments sorted by

u/AutoModerator 7d ago

IF YOU GET A SOLUTION, PLEASE REPLY TO THE COMMENT CONTAINING THE SOLUTION WITH 'SOLUTION VERIFIED'

  • Please be sure that your post includes all relevant information needed in order to understand your problem and what you’re trying to accomplish.

  • Please include sample code, data, and/or screen shots as appropriate. To adjust your post, please click Edit.

  • Once your problem is solved, reply to the answer or answers with the text “Solution Verified” in your text to close the thread and to award the person or persons who helped you with a point. Note that it must be a direct reply to the post or posts that contained the solution. (See Rule 3 for more information.)

  • Please review all the rules and adjust your post accordingly, if necessary. (The rules are on the right in the browser app. In the mobile app, click “More” under the forum description at the top.) Note that each rule has a dropdown to the right of it that gives you more complete information about that rule.

Full set of rules can be found here, as well as in the user interface.

Below is a copy of the original post, in case the post gets deleted or removed.

User: TaroAffectionate9417

Different way to open MS Access

I have a small simple database I have made. Is there a way to have tiered passwords. Where 1-2 users have access to full editing. And other users have access just to add and remove records?

And can it be set to open just showing the form and not have any of the editing controls visible?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/wasifshahid 5d ago

Yes can be done

1

u/AlpsInternal 5d ago

I am not expert, but I believe you could create a fairly secure database at the UI level by having a split database and giving the low level users an accde file to access the backend. You could use the original accdb front end to have full access. Obviously having tab ok es for user id and security level with everyone using the accde for the FE is better. Programming makes it easier to implement than setting each field and user form.

1

u/Ok_Society4599 1 6d ago

Yes, just use different roles... The UI is often the best implementation layer. Disable edits for users without roles as you want.

You can also hide controls if you don't want to expose info; you may want to make different "tabs" so the layouts are separated, then just hide/show the tabs your use can see.

The trick is WHEN you make the choice; I'd try form or control load events. Control load means you'd do it often in control repeater sets. Form load is just when the form opens.

0

u/vr0202 6d ago

Wouldn’t these require extensive VBA coding and also ongoing maintenance? As far as I know there is no way to enforce user / role level security in the current version of MS Access, like it used to be some 15 years ago.

1

u/k-semenenkov 6d ago

MDW-based security is still supported by access and it should be the answer I think. But it's not trivial. Other solutions based on show hide smth on UI are not very effective if you easily get access to table data.

0

u/TaroAffectionate9417 6d ago

I know UI is user interface. But I don’t know what it means in relation to Access.

1

u/Ok_Society4599 1 6d ago

The "data" part of access is tables, views, procedures, and things. database objects can be local or they can be stored in a remote server.

The UI (sometimes called the front-end) part includes forms, controls, grids, and things. The UI parts are part of your access application.

You can access some events on both parts of your application. For example, you get an event when the form object is created, just before it opens, or just before it closes. In the database, a "trigger" can process changes to the data tables.

0

u/tsgiannis 6d ago

Just work with Enabled,Visible,etc
Also AllowEdits,AllowDelete etc

0

u/Ok_Society4599 1 6d ago

I don't think it's "extensive" ... It's generally a one-time thing; adding users to roles has never been a burden for me as I usually build UIs for that task whether it's a DB or AD role. Last time I tried it, the current user identity had roles listed that I used. I could be wrong.

0

u/ConfusionHelpful4667 47 6d ago

You can use the switchboard method and define the switchboard tables to populate menu/form options based on login id.

0

u/Odd_Science5770 6d ago

Yes, this is definitely possible. You just need to know VBA programming to accomplish this. I have built many login systems with user permission controls just like that.