Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-17-2018, 06:29 AM   #1
sparklegrrl
Newly Registered User
 
Join Date: Jul 2003
Location: Texas
Posts: 99
Thanks: 0
Thanked 0 Times in 0 Posts
sparklegrrl
Send a message via ICQ to sparklegrrl Send a message via AIM to sparklegrrl Send a message via Yahoo to sparklegrrl
User Levels

Hello all. I have a quick question. Is there a way to set user levels in access?

Thanks in advance.

sparklegrrl is offline   Reply With Quote
Old 10-17-2018, 06:33 AM   #2
plog
AWF VIP
 
Join Date: May 2011
Posts: 8,934
Thanks: 10
Thanked 2,147 Times in 2,102 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: User Levels

No.

But if you want to explain what you would like to accomplish we can help you build it.
plog is offline   Reply With Quote
Old 10-17-2018, 06:35 AM   #3
sparklegrrl
Newly Registered User
 
Join Date: Jul 2003
Location: Texas
Posts: 99
Thanks: 0
Thanked 0 Times in 0 Posts
sparklegrrl
Send a message via ICQ to sparklegrrl Send a message via AIM to sparklegrrl Send a message via Yahoo to sparklegrrl
Re: User Levels

I need to assign users the ability to access everything or for example, job & shipping information but not the purchase order section.

sparklegrrl is offline   Reply With Quote
Old 10-17-2018, 06:40 AM   #4
plog
AWF VIP
 
Join Date: May 2011
Posts: 8,934
Thanks: 10
Thanked 2,147 Times in 2,102 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: User Levels

There's a few ways to accomplish this--none are foolproof for someone intent on screwing up your data.

1. Seperate front ends. Each user gets a special front end and only the forms that they can use are in it.

2. Permissions table. This requires you set up tables to track what permission each user has and what forms those allow access to. This will require VBA to lock down each form/report and require someone to maintain that list and act as an admin giving and rescinding permissions.
plog is offline   Reply With Quote
Old 10-17-2018, 06:46 AM   #5
sparklegrrl
Newly Registered User
 
Join Date: Jul 2003
Location: Texas
Posts: 99
Thanks: 0
Thanked 0 Times in 0 Posts
sparklegrrl
Send a message via ICQ to sparklegrrl Send a message via AIM to sparklegrrl Send a message via Yahoo to sparklegrrl
Re: User Levels

Ohhhhh I love that idea! It gives me something to go on. Thank you!

Also - side question. Is it true that Microsoft is going to stop supporting access soon?
sparklegrrl is offline   Reply With Quote
Old 10-17-2018, 06:53 AM   #6
plog
AWF VIP
 
Join Date: May 2011
Posts: 8,934
Thanks: 10
Thanked 2,147 Times in 2,102 Posts
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough
Re: User Levels

Yes, sometime around 2006. At least that was the date I was given when I heard that the first time.
plog is offline   Reply With Quote
Old 10-17-2018, 08:03 AM   #7
sparklegrrl
Newly Registered User
 
Join Date: Jul 2003
Location: Texas
Posts: 99
Thanks: 0
Thanked 0 Times in 0 Posts
sparklegrrl
Send a message via ICQ to sparklegrrl Send a message via AIM to sparklegrrl Send a message via Yahoo to sparklegrrl
Re: User Levels

Quote:
Originally Posted by plog View Post
Yes, sometime around 2006. At least that was the date I was given when I heard that the first time.
HA HA! Sooooooo..... not happening eh?

sparklegrrl is offline   Reply With Quote
Old 10-17-2018, 08:44 AM   #8
Vassago
Administrator
 
Join Date: Dec 2002
Location: Jacksonville, FL
Posts: 4,222
Thanks: 80
Thanked 85 Times in 81 Posts
Vassago has a spectacular aura about Vassago has a spectacular aura about Vassago has a spectacular aura about
Re: User Levels

Considering Access 2019 was just released and isn't set to end support until 2025, I would say you are pretty safe still using it.

https://support.microsoft.com/en-us/...cle/search/915
__________________
Vassago
Vassago is offline   Reply With Quote
Old 10-17-2018, 11:22 AM   #9
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 12,462
Thanks: 62
Thanked 1,174 Times in 1,074 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: User Levels

We hear the "doom and gloom" for Access every so often. Then something comes out that was meant to replace Access. Then that something falls so flat on its face that you can't even recognize it anymore. Then the next version of Access comes out and the cycle starts over again. I've heard the "Access is going away" many times. EVERY TIME, the thing meant to replace it either is so buggy that nobody buys it or it is so under-featured that nobody buys it or the customers jump on Microsoft's ... stuff ... and they abandon the glorious idea they had because nobody will buy it.

If you happen to come across posts by someone called NFK in this forum, he's a Microsoft hater and an extreme Access hater. Ignore him. He'll tell you 10,000 reasons why Access should be burned at the stake. But when pressed, he can't offer anything that anyone wants to use - or can afford to use.
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 10-17-2018, 11:27 AM   #10
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 12,462
Thanks: 62
Thanked 1,174 Times in 1,074 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: User Levels

On your original question (user levels), the way I did this was:

1. Users table - lists users and their role-number. #0 was disabled user, #1 was guest, #2 was "normal" user, #3 was admin user. But there is no reason you couldn't have more than that.

2. Each form's Form_Open event looked up the current user in the Users table, found the role number, and ran tests to decide (a) to not open the form or (b) to open the form but use the Form.AllowEdit and other .Allowxxxx flags to prevent unwanted action or (c) open the form and use the .Allowxxxx flags full access.

3. I also had the Form_Load stuff check for any special controls not compatible with a given role and to disable those controls. (Obviously, that is always some type of special-case check unique to each form.)
__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 10-21-2018, 08:44 AM   #11
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 27,431
Thanks: 13
Thanked 1,419 Times in 1,353 Posts
Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light Pat Hartman is a glorious beacon of light
Re: User Levels

The "Access is dead" rumors tended to originate from the SQL Server team since they "own" the Jet engine. MS added a desktop version of SQL Server in around 2000 which started the first set of rumors that "Access" was dead. Then in 2006, the Access team took Jet and turned it into ACE (.accdb format) and that started a new spate of rumors. I was in the NY MS office early in 2006 for a meeting and got into a very heated discussion with the regional SQL Server manager who was trying to convince me that Access was dead. Of course I had just come back from Redmond where I had a very early preview of A2007 so I knew how much time and money MS had invested in the new version of Access and it was clear that MS had no intention of killing Access anytime soon. The confusion is caused by people who don't know the difference between Jet/ACE and Access. People who call Jet/ACE Access (which includes the SQL Server team) think that when Jet is being dropped that Access is dead. I frequently correct people on forums because almost all the bad press that Access gets is actually directed at Jet/ACE because although they are truely fine products. They are still only desktop database engines and therefore no where near as robust as SQL Server. But for all of you who understand the difference, you know that Access is actually infinitely scaleable since when your FE is linked to SQL Server or some other RDBMS, the number of concurrent users is NOT controlled by Access but by the number of SQL Server CALs you own. This is because in a properly implemented Access application, each user has his own personal copy of the FE and there is NO file sharing except what is done by the server.

__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
User access levels fat controller Forms 42 08-02-2014 12:04 AM
How to create a Multi User login with user levels Brian62 Modules & VBA 14 09-27-2011 09:20 PM
User access levels using VB kirtney Modules & VBA 2 06-17-2011 02:26 AM
User Levels seanog2001 Forms 1 10-22-2009 01:16 AM
User levels Gillian Forms 2 03-12-2002 09:16 PM




All times are GMT -8. The time now is 07:40 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World