Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
 
Access Database Security Seminar
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   12 years ago

Learn how to properly secure your Access databases. Control and monitor everything your users can do in the database. Manage the complete flow of data into your database. Click here for a Complete Outline of the seminar and the topics covered.

 

Conditional Unlocking Upload Images   Link 
Joseph O'Malley 
4 months ago
Hi Richard. I've watched the seminar all the way though and my database is much more secure now! Quick Question for you regarding unlocking fields. Like in your code I have none of the fields lock in my form and subform if the user is an admin or manager. If the user is in group 3 (a regular employee I have only certain fields unlock for them. However, thinking through it I would like even those fields to be locked for these users once the "record complete" combo box is clicked as "complete". What would the best way to go about this? Right now my code is identical to your from this video.
Adam Schwanz
4 months ago
You can just use an if statement for that. Just say something if user is in group 3 and record complete combo = complete then lock everything else if user is in group 3 and record compete combo <> complete, then lock just a few.
Adam Schwanz
4 months ago
Use your own field names but

If IsUserInGroup(3) and Combo = "Complete" Then
  'Lock Fields Code
ElseIf IsUserInGroup(3) and Combo <> "Compelte" Then
  'Lock Few Fields Code
End If
Add a Reply
Compile Error Upload Images   Link 
Joseph O'Malley 
4 months ago
When trying to run the Create Links button I am getting an error showing " Compile Error: User- Defined type not defined" with the ws As DAO.Workspace portion of Dim ws As DAO.WorkSpace highlighted? Read More...
Joseph O'Malley
4 months ago
In my code I have DAO.Workspace , my phone accidentally put the capital on the S in my above message
Kevin Robertson
4 months ago
Sounds like you may need to add a reference to the Object Library
In the VB Editor click on Tools, then References.
Add the reference 'Microsoft Office 16.0 Access database engine Object Library'
Add a Reply
Bypass Key Buttons Not Working Upload Images   Link 
Joseph O'Malley 
4 months ago
Hi have checked my code multiple times and it matches completely but when I login and go to disable or enable the bypass key nothing happens. I don't even get an error. I also noted that the buttons appear about half a second after all the other buttons on the main menu. I'm not sure if that has anything to do with it as well. Read More...
Joseph O'Malley
4 months ago
Figured out the error with the bypass key!
Joseph O'Malley
4 months ago
I lied, I thought I fixed it but I guess not haha
Add a Reply
Locking Unlocking Fields Upload Images   Link 
Joseph O'Malley 
4 months ago
I have a subform which is bringing in linked data from another table, when writting the vba code for locking up all the fields & unlocking based on GroupID can I set all of that in the parent form or do I have to go into to the subform and write the code in there as well for the corresponding fields?
Adam Schwanz
4 months ago
Just lock the entire subform at once on the main form. Don't need to go in and lock them individually.
Joseph O'Malley
4 months ago
How would I go about doing that?
Add a Reply
Cant Go To New Record Upload Images   Link 
Jannette Jones 
11 months ago
I tried to use DoCmd.GoToRecord,,acNewRecord and it gets an error stating you cant go to that specific record
Richard Rost
11 months ago
Do you have Allow Additions set to Yes?
Add a Reply
Variable required error Upload Images   Link 
Jannette Jones 
11 months ago
i get an error when i try to run this code can you help
Private Sub Form_Current()
    'Locked the fields with a For Loop
    Dim Ctl As Control
    For Each Ctl.ControlType In Me Read More...
Richard Rost
11 months ago
Code looks OK to me. What line gives the error? I assume you close your loop and sub.
Jannette Jones
11 months ago
Varriable required cant assign to this expression
Add a Reply
Great Video Upload Images   Link 
Jannette Jones 
11 months ago
love this thank you
Richard Rost
11 months ago
You're very welcome. That's what I'm here for, and I love what I do - helping people by being nerdy. :)
Add a Reply
Password Not Seen Upload Images   Link 
Jannette Jones 
11 months ago
It seems like when i enter a password into txtPassword it not seeing that a password is being entered can someone help me with this?
Richard Rost
11 months ago
I need more information than that to help you. Did you follow the instructions from the video exactly? I can tell you changed things up, because I don't name things like txtPassword. LOL
Jannette Jones
11 months ago
when i step through the code it works but when i take step through off it doesn't work.
Add a Reply
User defined type not defined Upload Images   Link 
Gloria Tsakoumas 
12 months ago
Hello,
Can somebody please explain why the DisableBypassKey_ code gives me this compile error. The Dim DB As DAO.Database line is highlighted.
I am using Access 2016.
Thank you
Richard Rost
12 months ago
Try removing "DAO." Just say:

dim db as database

Make sure DAO is above ADO in your references.
Add a Reply
Lock Code Not Working Upload Images   Link 
jannette jones 
13 months ago
when i write my code for production user the form does not change im not sure why its doing this but here my code<>

Private Sub Form_Current()
'dim the control
Dim ctl As Control
'if he user is in admin do not lock the fields. Read More...
Richard Rost
13 months ago
It looks OK to me. I'm assuming your IsUserInGroup function is written correctly. Try stepping through it.
James Gray
13 months ago
Maybe I am just looking at it wrong but isn't the If statement remarked out?
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
 
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.
 
Subscribe
 

You may want to read these articles from the 599CD News:

8/1/2021Error Messages
7/31/2021Hide Inactive
7/29/2021Event Enrollment
7/28/2021Membership Database
7/27/2021Quick Queries #5
7/27/2021Loop Thru Fields in Table
7/26/2021First Monday
7/25/2021Missing Months
7/24/2021Center Vertically
7/23/2021DCount
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access database security seminar  PermaLink