Prevent others steal my Access Database

[Henro]

I too have this question,

How can I make sure that my name as a designer is, and always will be, in
the databases I make?

Grtz Henro

 

[Van T. Dinh]

We wait until 21 Feb 2004 (my date & time) to answer your question.

 

[Van T. Dinh]

Convert your database to MDE and if you want, implement Access Security.

 

[Douglas J. Steele]

As Van says, we'll answer your question after Feb. 20th.

You've posted with an incorrect date. Many people do that in a pathetic
attempt to get their messages at the top of the list. Some of the MVPs have
decided that we're not going to respond to people who do that until the
actual date they used in their post.

 

[Tony Toews]

sometimes it is't possible to make an mde from my database

Why? What specific problems?

by the way mde file can't sole the problem because it can be still copied
and run on other computes.
i appreciate to see any mor comments

Tools available from sites such as sysinternals.com can crack any
method you use to store a future date anywhere on a system such as in
the registry or a file. Unless it's encrypted. But even then if you
delete the date from wherever it's stored your app may think it's just
installed.

Thus I prefer to limit the number of records in one key table such as
5 units or 50 volunteers but allow unlimited access for everything
else. Once I get paid then I email them an encrypted file containing
the number of records they are licensed for as well as their company
name which goes on the bottom of every page of every report.

For more of my thoughts on this topic see my "Copy protection or how
to safely distribute a demo Microsoft Access Application" page at my
website.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[John]

One simple thing that I do is to get a dummy dll, save it in that PC's
system or system32 folder, try to call this dll as the first thing in your
forms. If it doe snot exist say 'Invalid installation, contact supplier". If
they try to copy on another pc the dll wont be there and db wont work. You
can ask why a dlll and not just any file, actually I use dll to check other
things too at startup.

Regards

 

[Henro]

Access ecurity is not possible due to restrictions on the machine the
database will be running on (Terminal Server in which Access can only be
started through osa9.exe and NOT through an adapted shortcut) but I wil
certainly look into the mentioned MDE option.

Thanks!

 

[Rick Brandt]

Access ecurity is not possible due to restrictions on the machine the
database will be running on (Terminal Server in which Access can only be
started through osa9.exe and NOT through an adapted shortcut) but I wil
certainly look into the mentioned MDE option.

Thanks!

I have been running an Access app with security for years on Terminal
Server. We just launch it with a batch file as our published app.

 

[Henro]

It is not a Terminal Server we control. We are using it, that's all. The
department controlling it will allow us to run Access databases as long as
we open them through the osa9.exe. I tried starting it through a bact file
but that won't work :-( They do not want toi change any zetting to be help
us.

Grtz Henro.

 

[Al]

Protect database with password
then add code to check computername and OS as follow

Create another table "sysinfo" and save the following
rs.addnew
SysCN = Environ("COMPUTERNAME")
SysOS = Environ("OS")
SysID = Now-1900
rs.update

when openning your program
hardcode the database password to open your programs
only not the the table view etc. and compare what saved in table sysinfo
against the System environment

Set rs = db.OpenRecordSet("SELECT * FROM SysInfo")

if rs.eof = False then
if rs!SysCN <> environ("COMPUTERNAME") then
msgbox "This is an un-authorized copy, please contact support"

Exit Sub
End the program.
end if '- Valid
End if '- EOF

Good Luck..!

 

[alien2_51]

fix your date

 

[DIOS]

Save it as an MDE file.

AGP

 

[Me]

Hi
could someone plz tell me how can i prevent others to copy my access
database to another computers and run it .
i have spent 1000 hours creating a database for a company, but they may sell
it without my notice.
How can i make my database work only on the PC which i have installed or in
other means is there any way to prevent access DBs work on other computers?
thanks alot

 

[Me]

Hey Van
sometimes it is't possible to make an mde from my database

by the way mde file can't sole the problem because it can be still copied
and run on other computes.
i appreciate to see any mor comments

 

[Guest]

Try to compile your code first. If part of your code can
not compile, fix it then make the .mde file.