Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 10-10-2018, 11:36 PM   #46
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,210
Thanks: 20
Thanked 864 Times in 849 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: User Level Security Wizard

Hmm, might have to tweak that query because it should be 9. That said, yes that is why you are having a problem seeing anything. You are going to need an admin area to update that if you plan on distributing this database.

Late here, almost 4:00 am will later about why 0 instead of 9.

__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 10-11-2018, 12:06 PM   #47
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,210
Thanks: 20
Thanked 864 Times in 849 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: User Level Security Wizard

I omitted a field in my query replace with the below...

Code:
strSQL = "INSERT INTO tblUsers ( uNetworkID, uFirstName, uLastName, ueMail, uLastLogon, uLogonCount, uSecurityID, uActive )" & _
            " SELECT GetUserID(), '" & Me.txtFirstName & "', '" & Me.txtLastName & "', '" & Me.txteMail & "', Now(), 1, 9, True"
That should fill in the 9.
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 10-11-2018, 02:41 PM   #48
DatabaseTash
Newly Registered User
 
Join Date: Jul 2018
Posts: 50
Thanks: 7
Thanked 0 Times in 0 Posts
DatabaseTash is on a distinguished road
Re: User Level Security Wizard

Thank you GinaWhipp that did the trick. It is now recording the number in the user table. I'm not able to test if it is read only though as there is no data in any of the tables. What would cause it to disappear?

Also, I feel really bad that you are doing this so late. Please don't omit sleep you need to get a good night's sleep. It can wait until daylight hours. No hurry.

DatabaseTash is offline   Reply With Quote
Old 10-11-2018, 03:07 PM   #49
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,210
Thanks: 20
Thanked 864 Times in 849 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: User Level Security Wizard

Yippee!

You are not the reason I omit sleep. I have a *day* job which often means I work late at night. However, if I start answering hate to just drop off as posters, like you, have no idea what time zone folks like me are in and might feel like you've been left to your own devices.

Not sure what you mean by data disappearing. Nothing in what you're doing make the data delete from the tables.
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 10-11-2018, 03:23 PM   #50
DatabaseTash
Newly Registered User
 
Join Date: Jul 2018
Posts: 50
Thanks: 7
Thanked 0 Times in 0 Posts
DatabaseTash is on a distinguished road
Re: User Level Security Wizard

Thank you

I open the tables and all the tables are empty. Even if I go through the back end file the tables are empty.
DatabaseTash is offline   Reply With Quote
Old 10-11-2018, 03:36 PM   #51
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,210
Thanks: 20
Thanked 864 Times in 849 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: User Level Security Wizard

Okay well I know the sample I got was empty. Did you empty the master by mistake? (That would be the only way they could go empty.
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 10-11-2018, 03:42 PM   #52
DatabaseTash
Newly Registered User
 
Join Date: Jul 2018
Posts: 50
Thanks: 7
Thanked 0 Times in 0 Posts
DatabaseTash is on a distinguished road
Re: User Level Security Wizard

No, I resaved the copy before stripping it back. I know I didn't accidentally delete from this database because all of the extra forms are there and all the graphics are still on the forms etc.

I have the data that I could reimport, might have to do that.

DatabaseTash is offline   Reply With Quote
Old 10-11-2018, 03:58 PM   #53
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,210
Thanks: 20
Thanked 864 Times in 849 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: User Level Security Wizard

I would do that and make sure to make a copy but the code provided ONLY looks at tblUsers, tblSecurities, ect. None of the other tables come into play. That said do not use those tables in any other queries for your database.
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
The Following User Says Thank You to GinaWhipp For This Useful Post:
DatabaseTash (10-11-2018)
Old 10-11-2018, 11:03 PM   #54
DatabaseTash
Newly Registered User
 
Join Date: Jul 2018
Posts: 50
Thanks: 7
Thanked 0 Times in 0 Posts
DatabaseTash is on a distinguished road
Re: User Level Security Wizard

I'm doing a happy dance!!

The database is working really well!

I would like to start handing out front ends now. When I put it on other workstations the user form doesn't pop up only the switchboard does. Once I enable the database the switchboard disappears. I am only trying to use a .accdb. I tried to change it to a ACCDE file but it won't allow me.

Is this a trust centre issue? They are all on the same network and have permissions to the folder that the database is saved in.
DatabaseTash is offline   Reply With Quote
Old 10-11-2018, 11:34 PM   #55
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,210
Thanks: 20
Thanked 864 Times in 849 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: User Level Security Wizard

They don't need permissions to the Backend, they need Rights to the Backend. They need the Frontend to be in a Trusted Location.

That said if putting it in a Trusted Location is not working then it sounds like you need to test on a *clean* machine to make sure everything is set up correctly.
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 10-14-2018, 05:37 PM   #56
DatabaseTash
Newly Registered User
 
Join Date: Jul 2018
Posts: 50
Thanks: 7
Thanked 0 Times in 0 Posts
DatabaseTash is on a distinguished road
Re: User Level Security Wizard

Thank you! I got it to work on the workstation by just manually adding them into the table. For some reason their computer didn't like the New User Form. The read only works well on the forms. There are a couple of menu options that result in a query. Is there a way of adding that same script to the query to make them read only too?
DatabaseTash is offline   Reply With Quote
Old 10-14-2018, 06:07 PM   #57
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,210
Thanks: 20
Thanked 864 Times in 849 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: User Level Security Wizard

Hmm, that is odd, glad you got it solved. Though I would probably still be at that machine to find out its problem.

You can't make queries Read Only and truth be told you NEVER want your Users in queries. Users should ONLY access data via Forms.
__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
Old 10-14-2018, 06:13 PM   #58
DatabaseTash
Newly Registered User
 
Join Date: Jul 2018
Posts: 50
Thanks: 7
Thanked 0 Times in 0 Posts
DatabaseTash is on a distinguished road
Re: User Level Security Wizard

Oh okay, thank you. I will get busy creating forms for them then.

Thank you sooooooo much for all your help! I really appreciate it!! You are a CHAMPION!!!! Everyone is so excited to start using the database.

THANK YOU!
DatabaseTash is offline   Reply With Quote
Old 10-14-2018, 06:19 PM   #59
GinaWhipp
AWF VIP
 
GinaWhipp's Avatar
 
Join Date: Jun 2011
Location: Ohio, USA
Posts: 5,210
Thanks: 20
Thanked 864 Times in 849 Posts
GinaWhipp has a spectacular aura about GinaWhipp has a spectacular aura about
Re: User Level Security Wizard

Glad we finally got it worked out. You're most welcome!

__________________
Gina Whipp
Microsoft MVP (Access 2010-2015)


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
GinaWhipp is offline   Reply With Quote
The Following User Says Thank You to GinaWhipp For This Useful Post:
DatabaseTash (10-14-2018)
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question User-Level Security Wizard Task3G General 3 09-30-2009 07:45 AM
user level security wizard help please stanat20 General 0 10-07-2007 05:18 AM
User Level Security Wizard garywood84 General 2 08-24-2006 06:16 AM
user level security wizard samer General 1 04-02-2004 07:28 AM
user level security wizard plonker General 8 03-14-2003 01:05 PM




All times are GMT -8. The time now is 05:48 PM.


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