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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Distribute as an accde, and use this:

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

Jim.
1
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

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
Jim Dettman (Microsoft MVP/ EE MVE)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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL 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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.