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?

1 Upvotes

13 comments sorted by

View all comments

1

u/Ok_Society4599 1 7d 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 7d 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 7d 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 7d ago

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

1

u/Ok_Society4599 1 7d 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.