Securing my database!

B

Bob V

Am I crazy or could this be Done!!
My MS Access Database has a Form Called [frmCompanyInfo] their is say 4
fields That's have to have data
CompanyName
BankName
BankAddress
BackAccount
BankAccNumber
Would it be possible to have a module that would take say the 2 digit or
letter turn it into a number times it by say 753 which would have to be
entered on that form the data base to be operational, the Module would be
password protected to find out what its doing, if the 2 space was blank it
would default to a number say 9............Anybody's thoughts would be
appreciated.......Just don't want my friends coping it to their friends for
there use...........Bob V
 
J

John W. Vinson

Am I crazy or could this be Done!!
My MS Access Database has a Form Called [frmCompanyInfo] their is say 4
fields That's have to have data
CompanyName
BankName
BankAddress
BackAccount
BankAccNumber
Would it be possible to have a module that would take say the 2 digit or
letter turn it into a number times it by say 753 which would have to be
entered on that form the data base to be operational, the Module would be
password protected to find out what its doing, if the 2 space was blank it
would default to a number say 9............Anybody's thoughts would be
appreciated.......Just don't want my friends coping it to their friends for
there use...........Bob V
Click to expand...

YOu can do better than that, although no desktop database can be secured past
the ability of a skilled and determined hacker to break into.
Download the Microsoft Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Print it out. Read it, carefully.

Get a good night's sleep.

Read it AGAIN, all of it, even MORE carefully.

Make a backup of your database.

Follow the security instructions, step by step. I will often check them off on
the printout (and I've done this many times).

This will let you specify which tables, forms, reports, etc. any user can see.
You can define multiple user ID's, multiple user groups, etc.

I have NO idea what you mean by your 753 and 9 and so on... but any "home
grown" security system will be very easily broken by anyone with a modicum of
programming knowledge.

John W. Vinson [MVP]
 
T

Tom van Stiphout

On Thu, 17 Jan 2008 12:22:51 +1300, "Bob V" <[email protected]>
wrote:

Unlike John the way I read your mesage (also skipping the 753 part) is
that you want to give your friend your application, but make it
impossible for this app to work on your friend's friends computers.

This does not require workgroup security like John was suggesting, but
some kind of Activation scheme. There are many ways to do that, but
because of the nature of security, the exact methods shall remain
secret. Keywords: hidden, system, registry, text file, computer name,
domain name, etc.

One publicly available way is to require a dongle, sometimes called a
hasp: a small device in the serial port or usb port that your app can
check for. I'm sure you can google for it.

-Tom.
 
J

John W. Vinson

Unlike John the way I read your mesage (also skipping the 753 part) is
that you want to give your friend your application, but make it
impossible for this app to work on your friend's friends computers.
Click to expand...

Ah... you're probably right, Tom. I didn't see that interpretation.

John W. Vinson [MVP]
 
M

msnews.microsoft.com

...no desktop database can be secured past
the ability of a skilled and determined hacker to break into.
Click to expand...

LMAO

Dimbulb MVP.

3DES cryptography in VBA, for example... 1 line of code and a 4096-bit
key...

Dim encStream As New CryptoStream(ms, _
TripleDes.CreateEncryptor(), _
System.Security.Cryptography.CryptoStreamMode.Write)

Not even the NSA would be able to crack it with a thousand years of
supercomputer processing time.

Say, have you ever tried thinking? Even just once?
 
M

msnews.microsoft.com

Tony Toews said:
And you are an anonymous coward.
Click to expand...

Oh, really? And what law of what land is it that requires posters to
newsgroups to be identifiable by name? No doubt if my real name were Fred
Bloggs and I posted with that then you would run up the ladder of inference
like a mad rat with its butt on fire and hurl insane accusations of
anonymity at that name too.

Before you try to dodge the two salient points just brought to your
exceedingly meagre attention span, I strongly recommend that you brush up on
a rather simple network utility called WHOIS.

NNTP-Posting-Host: 210.1.196.98

address: Pipeline Internet Providers Pty Ltd
address: 6/87 Reserve Road
address: Artarmon
address: NSW 2064

Anonymous coward, you say? You less than useless, know-nothing fool.
Go away.
Click to expand...

No. How about you grow a brain?
 
T

Tony Toews [MVP]

msnews.microsoft.com said:
Anonymous coward, you say? You less than useless, know-nothing fool.
Click to expand...

Already did all that.

You're still an anonymous coward.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
M

msnews.microsoft.com

Tony Toews said:
Already did all that.

You're still an anonymous coward.
Click to expand...

So, which do you feel is more cowardly, posting with a valid IP address but
without a real name, or cutting out all of your detractor's text and running
off to hide in the vain hope nobody will notice you were too chicken to
address the points being made?

PS: Why are you repeating yourself?
 
B

Bob V

So Guys what am I going to do about trying to Secure my database , even if
they would have to find some one to try and crack it , would be better than
nothing!! thanks Bob
 
J

John W. Vinson

So Guys what am I going to do about trying to Secure my database , even if
they would have to find some one to try and crack it , would be better than
nothing!! thanks Bob
Click to expand...

Sorry about the intrusion... did you see my previous response? Here it is
again:

Download the Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Print it out. Read it, carefully.

Get a good night's sleep.

Read it AGAIN, all of it, even MORE carefully.

Make a backup of your database.

Follow the security instructions, step by step. I will often check them off on
the printout (and I've done this many times).

Unfortunately, if you have A2007, they've taken the security features out.
You'll need to - at least - use A2002 .mdb format, and (I'm not sure, I don't
have 2007) use an older version to secure the database. Other than that the
security whitepaper covers all versions of Access from Access95 through
Access2003.

John W. Vinson [MVP]
 
M

msnews.microsoft.com

Bob V said:
So Guys what am I going to do about trying to Secure my database , even if
they would have to find some one to try and crack it , would be better
than nothing!! thanks Bob
Click to expand...

I am drawn to wonder if you, or anyone else for that matter, have ever
thought about asking google your questions... in fact, I'm drawn to wonder
if any of you have ever thought.

Results 1 - 100 of about 156,000 English pages for how do I secure my access
database?. (0.31 seconds)

Howto create a secure MS-Access (MS-Jet) database programmatically...
ACC: Microsoft Access Security FAQ Available in Download Center...
How to Unsecure a Secure Access Database - Access / VBA Articles

Results 1 - 100 of about 85,500 English pages for how to secure an access
mdb. (0.58 seconds)
Making an Access File More Secure - Access - Microsoft Office Online

Results 1 - 100 of about 120,000 English pages for Making an Access File
More Secure - Access - Microsoft Office Online. (0.33 seconds)

Do you also need help working out how to get to google?
 
B

Bob V

Thanks John will do as I have MS Access 200..Bob

John W. Vinson said:
Sorry about the intrusion... did you see my previous response? Here it is
again:

Download the Access 2000 Security FAQ:

http://support.microsoft.com/kb/207793/en-us

Print it out. Read it, carefully.

Get a good night's sleep.

Read it AGAIN, all of it, even MORE carefully.

Make a backup of your database.

Follow the security instructions, step by step. I will often check them
off on
the printout (and I've done this many times).

Unfortunately, if you have A2007, they've taken the security features out.
You'll need to - at least - use A2002 .mdb format, and (I'm not sure, I
don't
have 2007) use an older version to secure the database. Other than that
the
security whitepaper covers all versions of Access from Access95 through
Access2003.

John W. Vinson [MVP]
Click to expand...
 
B

Bob V

And to you. you Idiot I have had back up help when things don't go right
with my first reply post. Now Idiot you don't get that on GOOGLE!!
 
M

msnews.microsoft.com

Bob V said:
And to you. you Idiot I have had back up help when things don't go right
with my first reply post. Now Idiot you don't get that on GOOGLE!!
Click to expand...

You seem upset, Blob. Are you going to burst a blood vessel and mess up the
carpet?
 
Top