473,385 Members | 1,973 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Levels of User Access

4 2Bits
Good afternoon!

So - the database I am currently working on has 2 FORMS; one for adding new clients, one for editing existing ones. I need 4 levels of user access for the DB:

AUTHORISED USER: Will be able to run queries and reports, but not access the Forms or the Tables.

APPROVED USER: Will be able to do as an AUTHORISED USER but also use the EDIT PARTICIPANT form to change data.

SUPER USER: Can use both forms, so edit and ADD new clients.

SUPER ADMIN: As for the SUPER USER, but can also access all the Tables in the Database - basically have access to everything as if controls hadn't been set.

I have never done this before - could anyone offer any pointers on how to achieve, or start to achieve this?

Many thanks,

MrBee
May 10 '21 #1
2 2113
Rabbit
12,516 Expert Mod 8TB
We have no idea what database you're referring to since you posted this in general
May 11 '21 #2
Nauticalgent
100 64KB
The OP is referring to MS Access. He/She cross-posted this on AWF and has received some replies but has not responded yet.
May 12 '21 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

7
by: indie | last post by:
how to make a user management in php, i mean that i want to limit the user access to my page. the script will not allow 2 user have an access to my page at the same time. the script only allow 1...
2
by: Dustin | last post by:
With MS SQL 2000 Enterprise Manager, is there a way to allow a user access to only a few tables, but deny the user access to the rest without having to go to all of the tables and denying access?...
3
by: canigou9 (remove your socks to reply) | last post by:
(cross posted - comp.databases.ms-access, microsoft.public.access) Hello folks - this is my first post here, after a short lurk. I have written an application in Access2002 for a friend's...
1
by: intl04 | last post by:
Are there any problems with multiple user access to the same Access database on a shared network drive? I have 'shared' chosen for 'default open mode'. As for the record locking properties, I...
5
by: premmehrotra | last post by:
I currently have a multi-user access database which is put on a shared drive L: on a Windows Servers. Entire database is one file premdb.mdb. Users access this database from their laptops....
0
by: F I S H | last post by:
The site I am going to build has roughly 1000 html, php, asp, mp3, pdf, swf, doc. jpg, txt files etc....... I put them in 100 different folders. 200 users will be given access to 10 folders...
0
by: islandfong | last post by:
Hi, I am using ASP.NET 2.0 to implement a user access control system. The idea is that I would allow users (admin) to create new role, new user, assign user to role and the role is given...
1
by: jsd219 | last post by:
I have a fairly simple login in script and I need to make it have two levels of access not one. can anyone help me with this? The script is below: <?php // we must never forget to start the...
6
by: julietbrown | last post by:
I have been wandering through Google all day, getting lots of data but not much information! I have been developing what was originally seen as a single user Access db for a small charity. ...
5
by: kibokoyao | last post by:
Level User Acces hey guys! i need help! look this: i need to know better idea to implement in the system, "User Access level". i begin , creating groups where exists a "admins" and...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.