Newbie Developer: want to embed a license key facility in an access 2003 app.

C

Carriolan

Hi, I have a access 2003 app which I want to distribute; My questions
are:
1. How do I embed a license key / registration key to protect the
product?
2. Which is the best installer package (ease of use and value)?

Regards

Carriolan
 
A

Albert D. Kallal

Carriolan said:
Hi, I have a access 2003 app which I want to distribute; My questions
are:
1. How do I embed a license key / registration key to protect the
product?

You can roll your own system. There is some ideas here:

http://www.granite.ab.ca/access/demo.htm

2. Which is the best installer package (ease of use and value)?

I like the free Inno Installer, and use it for all of my ms-access clients.
(I am talking about distribution of a mde file here...not installing
ms-access). I also find Inno more appropriate for sending clients upgrades,
and bug fixes then compared to the ms-access developers edition.. You can
find it here:

http://www.jrsoftware.org/isinfo.php

However, are you talking about using the developers edition of ms-access?
The
developer edition allows your to package, and legally distribute a ms-access
runtime that allows your mde file to run. This resulting package can thus be
installed on a machine that does not have ms-access installed, or fact does
not have a2003 installed. So, to package up ms-access, regardless of
whatever installer you eventually use..you MUST purchase the developer
extensions to do this. You can find out more about the developer extensions
for ms-access here:

http://msdn.microsoft.com/office/technologyinfo/devtools/accessextensions/default.aspx


Not knowing about the kinds of distribution you want, you should be aware
that the developer extensions do give you the rights and ability to package
a
royalty free application. However, after purchasing the developer edition,
depending on your needs (or experience), you should also consider purchasing
some scripts from sagekey. They sell scripts for InstallSheid, and also the
windows installer (windows scripts would be better, since then you don't
also have to purchase installSheild).

Spend some time browsing here:
www.sagekey.com
 
N

Nick Coe \(UK\)

Further to Albert's post, another couple of packages;

For registration and locking/unlocking demo to full version
etc:
KeyedAccess from Peters Software. Peter's support is first
class.
http://www.peterssoftware.com/ka.htm

For building and editing installation packages use these two
together:
NSIS http://nsis.sourceforge.net/
and NISEDIT http://hmne.sourceforge.net/

If I need to bundle the Access runtime then I use the
appropriate Office Developer version. If it's only an MDE
FE with MDB BE and Help file(s) then NSIS/NISEDIT is an
excellent combination and works well for me.

--
Nick Coe (UK)
Available - Will work for money :)
http://www.alphacos.co.uk/ AccHelp + pAnimal
http://www.pjandcoe.co.uk/ TShirts with Bark Factor!

In Carriolan typed:
 
C

Carriolan Shinobi

Hi Albert thanks for your suggestions, which I am now well on the way
through. To be more specific I want to distribute and instal an MDE
application together with fonts. I found installers with licence key
security, but once the programs are unpacked they lose their
protection. Hence I am looking for a licence key feature that I can
build into an MDE file.

Rgds Carriolan
 
C

Carriolan Shinobi

Thanks Nick - Am working through your suggestions to night.
Regards Carriolan
 
A

Albert D.Kallal

Hi Albert thanks for your suggestions, which I am now well on the way
through. To be more specific I want to distribute and instal an MDE
application together with fonts. I found installers with licence key
security, but once the programs are unpacked they lose their
protection. Hence I am looking for a licence key feature that I can
build into an MDE file.

What I do is build a small text file (named .dll to confuse users). I then
simply put in the name of the company into this file. (along with check-sum
routine with some cool math in it...so if you modify the company name..the
license key will fail).

Now, in large friendly letters in the about and start-up screens, and on all
reports the company name appears.

The above idea really depends on how the software is going to be
distributed. I rolled my own "key" system which was less then a days work.
While the code base does not need to be changed, I do in fact generate a
related .dll file for each customer. The install thus does NOT even requite
the users to enter the customer info (as I done that for them!). (users find
all that stuff a pain anyway).

So, the downfall of this is that I have to enter this stuff for each
customer. I am VERY close to changing this, as I want larger (and easier)
distribution here.

I will say that the beauty of this system is that the install is easy easy
easy. And, employees can thus steal (copy) the program when they move on to
another company. (they don't have to write down some serial number key etc).
Just pop the disk in, and install. (actually, I am using the web in addition
to CD's to provide the installs to customers).

Often, that other company the employee moves to is a competitor. And,
having the company name appear on reports, and also the company name shows
on the main form also. You VERY quickly find that the employee is going to
his/her new boss asking for my application to be purchased. I need this
great program that I used when I worked at such and such.

I cannot stress how important the above is. I know for a fact that 5+ copies
of my application this year have been sold on the above scenario (and, I am
talking 5 different companies). If a person can easily copy the application
and use it, they will. (so, let them!!!).

I always been amazed at how much copied the office97 disk was. Many
companies I did work for had one copy for 30+ machines. Thankfully, virally
ALL of the customers I now have (and including that one that copied office)
are now all on legitimate versions of their software (and, virtually all of
them are now office 2002 or later and windows xp). I think these companies
simply felt a bit guilty, and further the newer licensing systems that MS
uses really helped. Further, most companies that have any success want to be
viewed as legitimate. How can you encourage honest behavior when you got
pirated software all over the office? So, most companies are quite good, but
you a little "bit" of encouragement for them.

So, make your install very easy, but bond a name to it, and dispense even
with a serial number key. However, the above type approach is good up to
about 100+ customers, after that, you will want an approach that scales
better (ie: no new work for each copy sold). And, I suppose it depends on
the kind of software. My events manger software is VERY sales orientated
system with CRM built in. And, sales reports in terms of dollars sold etc do
have the company name appearing on the top of each report. (hard to use that
in another company meeting!!).

If your product was some type of editor, or graphics system, then users
might not mind using something with another company name on it since no one
else will really see this fact. (again, depends on the type of software you
made). However, you did desing it to operate with differnt company
names...right?

So, I think the kind of approach you choose is much going to depend on how
many copies you plan to sell, and what kind of software, and the target
audiance.

I like my current approach, but this approach of mine does currently requite
user interaction on my part to build the license key.
 
C

Carriolan Shinobi

Hi Nick - The Keyed Access looks exacly what I was looking for -
thanks. Not sure about NSIS yet. I have to check out whether or not it
can instal font.
Regards Carriolan
 
C

Carriolan Shinobi

Albert - thanks for your help. I am afraid that I am pretty ignorant
on this subject. I want to distribute an Access MDE application wihich
is locked together with fonts. Nick recommended a site for the Keyed
Access security, similar to SageKey. So what I do not understand is
what are scripts used for?

Regards Carriolan.
 
A

Albert D.Kallal

Albert - thanks for your help. I am afraid that I am pretty ignorant
on this subject. I want to distribute an Access MDE application wihich
is locked together with fonts. Nick recommended a site for the Keyed
Access security, similar to SageKey. So what I do not understand is
what are scripts used for?

The scripts are mainly used to installed the ms-access runtime system. It is
NOT clear from your posts if you are going to require that the users go out
an purchase office 2003 (access) to run your application. You can't just
distribute a mde by its self, as you still need ms-access to run it. So,
either you

1) require your users to go out and purchase ms-access to run the mde

2) you write your application to work with the runtime system, and thus
users do NOT need ms-access installed to run your mde

So, the sagekey and scripts will referring to option #2. Remember, the
runtime system still is in fact installing a version of ms-access, and that
is rather LARGE program to install into a users computer. So, those
"scripts" from sagekey make the process less painful (and less support calls
to your support people for problems when they install the application). I
mean, if you send out 1000 copies, and then have 30% of those installs have
a problem, you just got 300 phone calls. At 10 minutes per phone call, that
makes 3000 minutes, or 50 hours of support time. When you include phone
tag, and returning phone calls, you are talking about a good two-three weeks
of solid support time on the phone for your customers. So, ensuring that
your installing routines are trouble free is a big deal. Get this wrong, and
you will have 100's of very mad customers, and using up tons of time of your
supprot people will cost a lot of money that could be used else where....
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top