Security and an Autoexec Macro

[Hammer]

Hello,

I have created MS Access dbase that will sit on a workstation that multiple
people will have access to. I am concerned someone will make a copy of this
file. Is there anyway for me to protect this file from theft.

I’ve thought about password protecting the file but several people will have
the password so this may not work.

Is there anyway for me to disable the file after a certain date? Could I
write some code that says something like … if today’s date is greater than
date=X, then close file and exit access. I’d kind of like this type of code
to run before my Autoexec macro runs or I could run it within the Autoexec
Macro using RunCode.

Any ideas?

 

[Jeff Conrad]

in message:

Hello,

I have created MS Access dbase that will sit on a workstation that multiple
people will have access to. I am concerned someone will make a copy of this
file. Is there anyway for me to protect this file from theft.

I've thought about password protecting the file but several people will have
the password so this may not work.

Is there anyway for me to disable the file after a certain date? Could I
write some code that says something like . if today's date is greater than
date=X, then close file and exit access. I'd kind of like this type of code
to run before my Autoexec macro runs or I could run it within the Autoexec
Macro using RunCode.

Here are some links/samples that should help with this topic:

http://members.shaw.ca/glenk/access2000.html
Look for the downloads:
"Updated have Database Expire After 30 Days Of Use"

"Updated have Database Expire After 30 Days Of First Being Opened."

MVP Tony Toews' thoughts on demos/expiration coding:
http://www.granite.ab.ca/access/demo.htm

Peter De Baets has a product called KeyedAccess that will do this I believe:
http://www.peterssoftware.com/ka.htm

Paul Overway has something similar here:
http://www.logico-solutions.com/
--Go to Add-ins/Extras area and look for "Logico Solutions MDB Lock"

Also try here:
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='LicenseLock

And for copyright protection these may be of help as well:
I have not used any of these myself.
Watch out for any possible line wrapping on these links.

http://directory.google.com/Top/Com...orks/COM/Components/Software_Protection/?tc=1
http://www.crypkey.com/products/copyprot/copyprot.html
http://www.sikandersoft.com/safeserial.html
http://www.copyprotection.com/

Good luck,