DB Passworts are not sure anymore

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I would like to make a DB unaccessible , but nowadays any password can be
cracked, even the one of a workgroup file.
Is there any way to hide fields of a table or make a table unreadable?
(Input Mask is not a solution)
 
Is there any way to hide fields of a table or make a table unreadable?
Click to expand...

Depends on the skill, persistance, and determination of the person who you're
trying to keep out. As you say, Access security can be cracked. If a higher
level of security is needed, move the data into SQL/Server and follow the best
procedures for SQL database security (strong passwords or passphrases, at
least 16 characters, mixed case, mixed alpha, number and punctuation).

If you want to keep the real power hackers or the NSA out... use a laptop with
no network connections and keep physical control of the computer at all times.

In my experience, though, the worst security holes are people who have a valid
reason to see the data... and then misuse it.

John W. Vinson [MVP]
 
Thanks for your reply - We offer a solution under Access and people can
download a trial version valid for 30 days from our web. Where can I keep
the download date of the gedownloaded version secure to be able to determine
the expire date (+ 30 days) for the prospect.
Writing in the registry is not sure anymore either, as software now can
determine where in the registry anything was written - or can you give me a
hint how or where to learn to convert dates into unrecognisable (or special
code) signs.
 
Thanks for your reply - We offer a solution under Access and people can
download a trial version valid for 30 days from our web. Where can I keep
the download date of the gedownloaded version secure to be able to determine
the expire date (+ 30 days) for the prospect.
Writing in the registry is not sure anymore either, as software now can
determine where in the registry anything was written - or can you give me a
hint how or where to learn to convert dates into unrecognisable (or special
code) signs.
--
Friedi






- Show quoted text -
Click to expand...

Hi

Maybe not as secure as you'd like but these 2 functions may help?

Public Function EncodeData(sData As String) As String

If IsNull(sData) Or sData = "" Then
Exit Function
End If

'Schmidt - msnews.microsoft.vb.general.discussion
Dim cnt As Long
Rnd -4
For cnt = 1 To Len(sData)
EncodeData = EncodeData & Chr$(Asc(Mid$(sData, cnt)) Xor Rnd *
99)
Next

' MsgBox EncodeData

End Function

Public Function JumbleData(sData As String) As String

If IsNull(sData) Or sData = "" Then
Exit Function
End If

'Larry Serflaten - msnews.microsoft.vb.general.discussion
Dim i As Long
Dim j As Long

For i = 0 To Len(sData) \ 4
For j = 1 To 4
JumbleData = JumbleData & Mid$(sData, (4 * i) + 5 - j, 1)
Next j
Next i

' MsgBox JumbleData

End Function

Thanks
James

http://www.jamesoleary.co.uk/
 
Thanks James any input helps. I will investigate your 2 functions and
certaily keep you posted

Thanks
 
Back
Top