Link to home
Start Free TrialLog in
Avatar of ML
MLFlag for United States of America

asked on

How to share a database for a fee

What would be the best way to distribute an Access 2016 database for a fee?  I've created a database that runs similar to a kiosk and have packaged it with runtime files and all necessary imagery and .ico files.

Is there a way to secure this to keep it from being passed around?  I've looked around for solutions and haven't found any, but I thought I'd try the forum here.  I feel like the only way to keep it from being given around freely is to have it hosted online, but I don't see where Access has this capability.  We do run SQL Server for our GIS, so that may be a solution.  

Just for information, it's a region-wide contacts database for city and county governments.  Thank you!
Avatar of ste5an
ste5an
Flag of Germany image

[..] for city and county governments
Use legal contracts. Any kind of "copy protection" is hard to make foolproof and  can introduce issues on the client side.

Well, you can host the data for example in SQL Azure and use linked tables in Access.
I guess the best way is really to store your database in a Cloud solution (Azure, Amazon, ...) and provide the access only to who's paying for it.
Distribute as an accde, and use this:

http://www.peterssoftware.com/ka.htm

Jim.
Avatar of ML

ASKER

ste5an and Vitor, I really like the way we will be able to have this database in the cloud and online.  I just need to take some SQL classes lol.  That's where we'll be eventually.  Thank you!
Avatar of ML

ASKER

Jim, so this is like what software programs use to keep their registration keys from being duplicated?  Have you used this?  This looks awesome!

Thank you!
ASKER CERTIFIED SOLUTION
Avatar of Jim Dettman (EE MVE)
Jim Dettman (EE MVE)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ML

ASKER

Thank you all so much!!  Vitor, I will DEFINITELY be looking for  your tutorial today!  And Jim, I'm going to download this tool.  I think I have exactly what I need to proceed.  Y'all have been the most help.
Avatar of ML

ASKER

I wish I could give you both "best solution".  Both solutions will be utilized.