12/6/2021: I'm doing some work on the site this morning. If you notice anything crazy or not working, email me: amicron@gmail.com   [dismiss]
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 Security Seminars
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   7 years ago

If you need to SECURE your Microsoft Access databases, I have multiple seminars to help you:

- Access Security Seminar
- Access Split Database Security Seminar
- Access Data Encryption Seminar
- Access Registration Seminar

Microsoft Access, by itself, does not have an easy way to provide multi-user security. There used to be a User Level Security Wizard back in Access 2003 and before, but Microsoft removed it starting with Access 2007. However, there are several techniques you can use to lock down your database to prevent unauthorized access and secure your data.

If all you need is to protect your database so that only YOU (or a small set of trusted users) can access it, you can simply create a Database Password. That's a single password for one user. If you know the password, you can use the whole database.

Next if you want to secure the DESIGN of your database, you can encrypt it and create an ACCDE File. This is a "compiled" version of your database. Your users can view and edit data, but they can't get into the design of your forms, reports, macros, and VB code modules. I cover this in my Access Expert Level 21 class.

I have several different seminars that show you various techniques to protect your database. The first is my highly recommended MICROSOFT ACCESS SECURITY SEMINAR. In this seminar, you learn the basics of locking down your database to prevent unauthorized access. Topics covered include:

- Create user and group security inside your database
- Unique individual logon usernames and passwords
- Control who has access to which database objects
- Send email notices from inside your database
- Create a detailed system log to track users
- Encrypt and secure your database files

That seminar will teach you how to protect your database to keep the average users from messing with it. Only the super-experienced hackers will be able to figure out how to bypass that security. If you need even more protection, however, my SPLIT DATABASE SECURITY SEMINAR will teach you how to protect your back-end data files against unauthorized use by breaking your database up into multiple tables and placing them in different Windows-level shared folders. If, for example, the majority of your users don't need to see the Accounting tables, you place them in a separate shared folder with unique security. This seminar covers:

- Set up multiple customer tables, one for normal data, one for sensitive data
- Build two customer forms; the sensitive form requiring a password to open
- Split your database into 3 files: front end and two back-end files for tables
- Create shared folders on your server or Windows PC
- Use Windows-level file & folder security to prevent access to the sensitive data
- Move the back-end files to the server and relink with the Linked Table Manager
- Encrypt your front-end database and create an ACCDE file

If all of that doesn't give you enough security, the next seminar will show you how to encrypt the DATA in your tables so that it looks like garbage. Unfortunately, Microsoft doesn't give us any way to protect the actual database tables themselves. So, if a malicious user who normally HAS access to the database decides he wants to copy your data for himself, there's really nothing to stop him. My ACCESS DATA ENCRYPTION SEMINAR will show you how to scramble the actual data in your tables so that even if someone downloads a copy of your ACCDB back-end file, once they open it, the information will look like gibberish. You will:

- Learn how to scramble data in your tables to hide sensitive information
- Convert text characters to their ASCII equivalent values and back
- Perform mathematical obfuscation on your data
- Control access to the form that handles the encryption / decryption

In my ACCESS REGISTRATION SEMINAR, you will learn how to protect your Access database so you can give or sell it to others, and they will be required to register their copy of the database with you. This prevents theft and piracy, and protects your intellectual property. Topics include:

- Discussion of database security concepts and our registration scheme
- How to create a startup form that autoruns when the database opens
- How to read and write values to the Windows Registry for a specific user
- Generating random numbers and developing a security key algorithm
- Timing out registrations after a specific time period. Great for subscriptions

Now, the single best way to protect your data is to use a database server program, like Microsoft SQL Server. However, setting up SQL Server can be costly and time consuming. I will be preparing a course series to cover SQL Server in the future. However, it is very possible to set up a secure database that will keep out 99.9% of all people, using ONLY Microsoft Access. These seminars show you how.

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.

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

12/3/2021Access Beginner 2
12/3/2021Access Beginner 2 Lessons
12/3/2021Access Beginner 2
11/30/2021Import Multiline Cells
11/30/2021Adam's Access Games
11/29/2021Prevent Close
11/22/2021Currency Symbols
11/13/2021Access Developer 36

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

YouTube Channel    LinkedIn
Keywords: access security seminars sql server encryption  PermaLink