Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Encryption (Access 2000 >)

    What are the effects of an encrypted DB <img src=/S/question.gif border=0 alt=question width=15 height=15>
    After I have encrypted a DB, I notice that I can still connect to the DB using a word processor to do mail merge. Should the records not be secured by the encryption to make them indecipherable to other applications?
    Regards,
    Rudi

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Encryption (Access 2000 >)

    Rudi,

    Have a look at : Microsoft Office Assistance: Encrypting a Database.
    <hr>If you want to help protect your secured database from unauthorized access by someone who is using a disk editor or other utility program, you can encrypt the database<hr>
    <hr>Note Encrypting an unsecured database has no effect because anybody can open the database with Access or Visual Basic for Applications (VBA) and gain full access to all objects in the database.<hr>
    As Word open an instance of Access to get the data, it is normal that it can be read.
    Francois

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Encryption (Access 2000 >)

    hi Francois,

    Thanx for your reply...but i am still not clear on this. I see from your attachment that User Level security does encrypt the DB too.
    I am still unclear as to what is the encrypt command for under the security menu.

    If I simply choose to encrypt a DB, it seems to have no effect. I would expect it to spit out jumbled text to any application or program trying to communicate with it!
    Maybe you can explain When and How i can use it!

    (sorry, i seem to be dumb in this question)
    Regards,
    Rudi

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Encryption (Access 2000 >)

    A little correction : The User-Level Security Wizard automatically encrypts your database.
    If you implement User-Level Security yourself, without the wizard, the database will not been encrypted automaticaly.
    Encryption is at the level that the data will be written to the hard disk. If a field contain Francois, with encryption there will be something totally other written to the disk. Lets say fkjeidns. If someone read the file with any program except Access, it will read fkjeidns, but if you use Access, who knows that the database is encrypted, fkjeidns will be decrypted to Francois.
    When you use a mail merge in Word, Word invoke Access to read the data and as it is Access, it knows that is is encrypted and fkjeidns, again, will be decrypted to Francois.
    When to use encryption ?
    When you don't want someone read the file at disk level to see what it contains. Of course, you should also implement User-Level Security because otherwise, the someone can use Access to read the file.
    I hope this clarify the things, If not post back.
    Francois

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Encryption (Access 2000 >)

    This is perfectly clear Francois! Thanx a million. What i did not understand was that incryption takes place at disk level. The way you explained it is very clear.
    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16> <img src=/S/ribbon.gif border=0 alt=ribbon width=15 height=15>
    Regards,
    Rudi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •