Solved Users restrictions (1 Viewer)

[Slim Shamble]

Goodevening Everyone,

i have an access database login form with 5 users login including The Admin. I want to restrict users from making changes when they login to use the database exception of the Admin user.

is that possible? Can that be done?

 

[isladogs]

Did you mean to mark this as solved?

Anyway, yes its possible.

In the users table add a Boolean field called Admin or similar.
Set the value true for the admin user and false for everyone else.

Create a function which checks that field value when users login.
Call it something like IsAdmin

Then at start up add code like this

 Is IsAdmin Then
 .... put admin user conditions here
Else
... put conditions for everyone else here
End If

You may also want to consider things like hiding the nav pane & ribbon for standard users. To do so, use database start up properties.
I'll explain that in another post if needed

 

[Slim Shamble]

Colin,

please can you include the conditions for me, dont know codings
. Should i upload a sample for you to fix it for me?

thanks

 

[isladogs]

First of all, you need to decide exactly what your users can / can't do.
Plan this bit carefully as the coding will depend on that

Adding the code may not be a trivial task depending on your requirements.
Therefore, it could take a while to do.

See what you can do yourself first before asking for additional help

 

[Slim Shamble]

I have no knowledge of coding and moreover, i have source for codes. Still can't find any. Anyone please? Am running out of deadline.

 

[isladogs]

Whilst you still haven't defined exactly what restrictions you require, I can tell you that what you are asking for will require both time and coding skill.

It also goes way beyond the level of help you can reasonably expect to get for free on a forum such as this. I would therefore suggest that you consider paying someone who has the necessary skills to develop this for you.

Good luck with your project

 

[Slim Shamble]

Ok, thank you. i guess i have to look up for another alternative.