Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  

News      User Comments     History     Notify Me

8/16/2015 8:28:58 AM
Access Registration Seminar
By Richard Rost   Richard Rost on Facebook Richard Rost on Twitter Richard Rost on Google Plus Richard Rost on LinkedIn Email Richard Rost

In the 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

This seminar is 50 minutes long. Click here for more information on the Access Registration Seminar including a complete course outline, sample videos, and lots more.

Permanent Link
Course Link: Access Registration Seminar
Keywords: access registration seminar
Page Tag: whatsnew
Post Reply

Secure Comment from Chris Thompson @ 1/20/2017
Alex, I would like to see something that is more secure than using the registry in such a well known location with unencrypted data - and yes I know you could encrypt the data before you put it out to the registry.  Items such as the those mentioned by Rick in his Summary remarks of this Seminar would be good. Of course, putting your own solution together using the various aspects of all these Seminars together is always possible.

Reply from Alex Hedley:

It all depends for what reason do you need it to be secure?
People will always find a way, so most of the time it is preventative or a delay tactic.
A call to a web service license checker is probably the next best step but then you need it always online.
Show Just This Thread        Post Reply
Program Settings Comment from Chris Thompson @ 1/20/2017
This is a quick note for those reading this forum and is a follow-up to Patrick Russell's 8/19/15 post. The "VB and VBE Program Settings" folder in the registry - if it doesn't exist - will be created in the path Rick has shown in the Seminar when you first use the SaveSetting function. The Path is automatically created by the OS followed by your settings located in that path. This behaviour was observed on Windows 10.

Reply from Alex Hedley:

Thanks Chris
Show Just This Thread        Post Reply
Access Registration Seminar Comment from Ibrahim Muhammad Gusau @ 3/13/2016
I am Very - very interested with your Tutorials, I very eager to learn  Database, so please I need your assistant on this section.

Thank you.

Ibrahim Muhammad Gusau

Reply from Alex Hedley:

What is your exact problem?
Show Just This Thread        Post Reply
Anti-Virus prohibiting Comment from James Gray @ 2/21/2016
Although I haven't tested this on my ambualance database yet (not ready for prime time yet ), I was wondering if potential customers' anti-virus software would prohibit writing to their registries?  Seems to me that this could be a potential problem...

Reply from Alex Hedley:

There could be restrictions imposed by some programs, you could ask for an exception to be put on
Show Just This Thread        Post Reply
Interesting Seminar Comment from jan nyberg @ 2/18/2016
This seminar was really interesting and easy to follow.
Im really interested in a part 2. :)

Reply from Alex Hedley:

Anything you'd like to see covered?
Show Just This Thread        Post Reply
Access Registration Seminar Comment from Fernando @ 1/24/2016
How i lock a access 2007 database

Reply from Alex Hedley:

The Security Seminar will also show you how.
Show Just This Thread        Post Reply
New Problem with CDATE Comment from susan g @ 12/27/2015
Receiving a run time error 13 - type mistmatch - I"m lost

Reply from Alex Hedley:

Can you copy and paste the code you are using?
Show Just This Thread        Post Reply
Seminar was simple and straight forward Comment from Chris Thompson @ 11/26/2015
Seminar was simple and straight forward. Would be interested in a Part 2

Reply from Alex Hedley:

Anything in particular you'd want to see Chris?
Was the addendum I made useful too?
Show Just This Thread        Post Reply
New passwords for end user Comment from Joseph R @ 9/28/2015
How about password expiration? The end user changing their own password?
Show Just This Thread        Post Reply
Comment from William Dowler @ 9/16/2015
I'd be interested in Part 2..... Bill D.
Show Just This Thread        Post Reply
Addendum Comment from Alex Hedley @ 9/9/2015
I've created an Addendum Tip that shows you how to create any Reg Key you want.

I've also created a mini .NET App for generating the Key needed for the User.
Let me know if you'd like to see how I built it or any additions/changes you'd like made to it.
Show Just This Thread        Post Reply
cmd and regedit Comment from Kevin Roberton @ 9/5/2015
To open The Registry Editor from the Command prompt, simply type in the full path. In windows 10 the path is:

Show Just This Thread        Post Reply
cmd and regedit Comment from MUBEEZI MICAH @ 9/2/2015
hi Rick!
when i open the command prompt and enter regedit, i get this feedback

Microsoft Windows [Version 10.0.10240]
(c) 2015 Microsoft Corporation. All rights reserved.

'regedit' is not recognized as an internal or external command,
operable program or batch file.


Is there a step i could have missed?

Thank you!


Reply from Alex Hedley:

Ctrl+R to open Run
Type 'regedit' into Run and click enter.
Can't remember if regedit is in path to open from cmd.
Show Just This Thread        Post Reply
Access Registration Seminar Comment from Richard R @ 9/1/2015
I recorded this seminar on a PC running Windows 10. I also tested it on a Windows 8 machine. Worked fine on both. Granted the Windows 10 box was previously upgraded from Windows 8 to 10, so that key may have already been there. I don't have a virgin Windows 10 box in my office right now. Does anyone have one that can confirm whether or not this key exists in Windows 10?

Either way, I will record an addendum lesson with how to set/read ANY registry key you want. I just figured the Get/SaveSettings functions would be the easiest for everyone to use.
Show Just This Thread        Post Reply
Access Registration Seminar Comment from Uriel R @ 9/1/2015
The splash screen will be a the initial form I suppose
Show Just This Thread        Post Reply
Access Registration Seminar Comment from Uriel R @ 8/22/2015
I thought about that make it as a "splash" screen when the database open but I would prefer if I can put it an "About..." in the control box like other applications.

Reply from Alex Hedley:

You don't need a splash screen, just a button on the Form with a image or ? that opens another Form.
Show Just This Thread        Post Reply
Win10 VB and VBA keys Comment from Shams @ 8/21/2015
Hi Richard, I also enjoyed the seminar.I have window 10, there is no VB and VBA Program Folder in HKEY_Current_User/Software can you update what other option do I have.
Show Just This Thread        Post Reply
Access Registration Seminar Comment from Uriel R @ 8/21/2015
Well, both. if you could include how to create and distribute an updated version would be perfect, but you also need to know how to keep track of the version that is distributed and check for the license for each version. Versioning also contribute to technical support since several of my clients have different versions and there is no way for them to check which version they have, so when they call me for support is pretty much me telling them how each version looks and if it fits the description we go from there.

Reply from Alex Hedley:

You could add a Table that stores this information and just have it as a popup form.

I think the distribution seminar is on the Waiting List.
Show Just This Thread        Post Reply
Computer Name is Key Comment from Brent Rinehart @ 8/20/2015
I wasn't thinking towards hostname but more towards computer hardware id's say like getting the hardware ID of the motherboard and integrating into the regetration some how.

Reply from Alex Hedley:

There is probably a WMI you could use to get it or maybe another Environ
Show Just This Thread        Post Reply
Win10 VB and VBA keys Comment from Patrick Russell @ 8/19/2015
Hi Richard, I enjoyed the seminar, but had a question.  I too have upgraded to Window 10, but when navigating into the registry I cannot find the VB and VBA Program Settings folder in HKEY_CURRENT_USER/SOFTWARE (i.e. Lesson 2 10:46)?

Reply from Alex Hedley:

I'll need to check on a Win10 box but have you tried the FIND option?
Show Just This Thread        Post Reply
Access Registration Seminar Comment from Uriel Ramirez @ 8/17/2015
This seminar should include how to do version control.

Reply from Alex Hedley:

Do you mean creating and distributing an updated version?

Or do you mean using something like Git about using msaccess-vcs-integration
I've not had a chance to test this yet.
Show Just This Thread        Post Reply
Computer Name is Key Comment from Brent Rinehart @ 8/16/2015
I love the new seminar been waiting for some good seminars to come, I want more. I just finished watching Part 1 and wanted to know how hard would it be to generate a code that ties the persons computer ID into the key and maybe there name, so say they call up and say I had to reinstall the program because I had to rebuild my computer, would that computer ID be uniqe to their computer only and it would prove they were trying to reinstall the program back on the same machine? Would this be hard to do?

Reply from Alex Hedley:

Open cmd and type HOSTNAME.

Dim sHostName As String
' Get Host Name / Get Computer Name
sHostName = Environ$("computername")

Dim sUserName As String
' Get Current User Name    
sUserName = Environ$("username")

You could use the techniques in the Security Seminar to get the currently logged in user.
Show Just This Thread        Post Reply

Add Your Comments or Subscribe
If you just want to subscribe to get email updates when the News is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
  Your Name:  Required
  Your Email:  NOT Public


Sorry about this step. It's just to keep the spam bots away:
  Verify: What is 8+2:
  Notify me when the News is updated.
  Remember Me for my next comments
Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead.

I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be.
As always, I promise to never give away your personal information to anyone else, ever.

NOTE: If you don't leave your name and email address, DON'T expect a reply. I can't promise a personal reply to everyone who posts here. I TRY my best, but I cannot guarantee it. If you don't leave your real name and email address, I won't even bother. I usually just hit DELETE. -Richard



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

7/19/2017Access Developer 2 and 3 Released
7/19/2017Microsoft Access Developer 3
7/19/2017Microsoft Access Developer 2
6/30/2017Access Developer 2 is Finished
6/7/2017Microsoft Access Developer 1
6/6/2017Access Developer 1 is Finished
5/18/2017Microsoft Access Advanced 6
5/17/2017Access Advanced 6 is Online
4/9/2017Microsoft Access Advanced 5
4/9/2017Microsoft Access Advanced 4

Visual Basicindex
Account Login
Online Theater
Lost Password
Free Upgrades
Insider Circle
Student Databases
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Live Chat
Customer Support
WalkThru Tutorials
Consulting Services
About Us
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Gift CDs
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP