Tracking Database Use

[BlackOnBlack]

Does anyone know of a way so I can track use of a database that I created? I want to make sure it is not subsequently stolen by employees who leave or otherwise used without permission. I was first thinking there is a way to ping me or send a secret email whenever the database was opened. I also thought there might be a way to have the database 'visit' a webpage that has Google Analytics since Google Analytics tracks website visits as well as provides IP and geographical information. Thoughts?

 

[Uncle Gizmo]

You might be able to make use of this Technique:-

Gmail From MS Access

 

[spikepl]

So you'd get a message and then what? Call your biker friends and give the user a beating?

 

[HiTechCoach]

Does anyone know of a way so I can track use of a database that I created? I want to make sure it is not subsequently stolen by employees who leave or otherwise used without permission. I was first thinking there is a way to ping me or send a secret email whenever the database was opened. I also thought there might be a way to have the database 'visit' a webpage that has Google Analytics since Google Analytics tracks website visits as well as provides IP and geographical information. Thoughts?

My Thoughts ...

Unfortunately securing an Access database from being copied is very difficult to do. Access is designed for that type of development platform.

If it were my project I would have probably done it web based.


I assume the database is already properly split. Yes?

I will also assume this is run on the local LAN since you did not specify.

To keep the back end database from getting copied I would first upsize the back end to MS SQL Server Express (it is free) or the full version if you got it.

Are you requiring a live internet connection before your database front end will open? If yes then you could create your own licensing server or use one of the services.

Also see: ActiveLock (Click here)

ActiveLock is a free ActiveX control created to help you to add registration features, protect your programs from piracy and sell your programs online!

 

[spikepl]

Thx HiTechCoach for the ActiveLock link - been looking for something like that.

 

[HiTechCoach]

spikepl,

Your welcome. Glad you found it helpful.

I have this any many other developer tools listed on my site. See: Access Developer Tools: Apps, Add-ins, VBA Code

 

[Vassago]

Make sure you disclose that your database does that. If you don't, you stand possible litigation for having features that send data without the user knowing. Even stolen software has gotten major companies in hot water over sending data without permission or acknowledgement from the user.

 

[HiTechCoach]

Vassago makes a great point.

It is common that the first time software runs or during installation it informs the user that it is protected software. They agree to the terms of use/EULA before it will run.