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!
MLGIS Program ManagerAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor President / OwnerCommented:
Yes.

I haven't used it myself, but others have and don't have any issues that I'm aware of.

 Peter has been in the Access market for a very long time, and this particular product as well.   I'm sure if it didn't work as advertised, I (and others) would have heard about it before now.

Jim.
1
 
ste5anSenior DeveloperCommented:
[..] 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.
3
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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.
1
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Distribute as an accde, and use this:

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

Jim.
1
 
MLGIS Program ManagerAuthor Commented:
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!
0
 
MLGIS Program ManagerAuthor Commented:
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!
0
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
ML, I was thinking in moving your Access to a cloud server so it will still be an Access database :)
But if for some reason you want to migrate to SQL Azure, I wrote a tutorial on how to create and work with a SQL Azure database. Just check in my MSSQLTips profile for the Azure section and read them by the order of published date (from oldest to newest).
1
 
MLGIS Program ManagerAuthor Commented:
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.
0
 
MLGIS Program ManagerAuthor Commented:
I wish I could give you both "best solution".  Both solutions will be utilized.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.