Page 1 of 3 123 LastLast
Results 1 to 15 of 39
  1. #1
    Join Date
    Apr 2008
    Posts
    189

    Question Unanswered: How to make a MDB file secure

    Hello,
    I'm back.
    As the banner says: it's been a while since my last post.

    Now I want to make my MDB project file secure.

    The only thing I need is that the users of the MDB or MDE file weren't able to read the data on the Tables.

    I just need that the users only can access to the data on the Tables using only my pre-designed Forms.

    Is there any way to do this? Or I need to go for an SQL Server?

    I've been reading about this software:
    http://www.mindwarp-consultancy-soft...-download.html
    Does any one knows about it?

    Also, I don't get if the MDE file could help me:
    http://help.lockergnome.com/office2/...ict146747.html
    http://office.microsoft.com/en-us/ac...578511033.aspx
    As I see only secures -a little more- the VBA code.

    Any ideas?
    As always: thank you in advance for your time and comments.

    Regards,
    pepemosca

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    The only way I ever feel that the data is secured is to put it on SQL Server. That in itself doesn't do much, but when you combine it with MDE, unbound forms and connecting to the server without using table links, the data starts to become quite secure.

    I often use a "low security" setup where the db window is hidden from the user and the "bypass shift key" is disabled. That stops most people opening it and getting access to the tables.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Apr 2008
    Posts
    189
    How do I "connect to the server without using table links"?
    What do you mean by that?

    Thanks!

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    That's another topic.

    Here it is: http://www.dbforums.com/showthread.p...05#post6315605

    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Apr 2008
    Posts
    189
    Thank you for the advice and the link!
    Last edited by Ben Au; 07-27-08 at 06:00.

  6. #6
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You're most welcome
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  7. #7
    Join Date
    Apr 2008
    Posts
    189

    Question

    Does anyone knows any way to code the contents of the tables?

    I mean, any way to encript the contents of the table and a VBA code to decript it?

    Any ideas?
    Thanks!

  8. #8
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    OMG!!

    * Runs away and hides under the bed *

    You could probably do it, but there would be a significant performance hit... and a significant development time hit too.

    And no, I have never attempted it. If I really want to secure the data, I always lean toward SQL server type data platforms.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  9. #9
    Join Date
    Apr 2008
    Posts
    189
    Quote Originally Posted by StarTrekker
    OMG!!

    * Runs away and hides under the bed *

    You could probably do it, but there would be a significant performance hit... and a significant development time hit too.

    And no, I have never attempted it. If I really want to secure the data, I always lean toward SQL server type data platforms.
    Yeah, I know. But my IT department charge me a loooot for a SQL Server access.

    I'm thinking about a different solution.

  10. #10
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    What about MySQL... that's free.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  11. #11
    Join Date
    Apr 2008
    Posts
    189
    Quote Originally Posted by StarTrekker
    What about MySQL... that's free.
    Yes, you are right.
    But I cannot share resources or services over the company network.
    I'm stuck in this dilemma.

  12. #12
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Bugga. If it were me, I'd probably get one of those cheap hosting packages with MySQL and use my own server.

    Have you considered Access' inbuilt encryption?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  13. #13
    Join Date
    Apr 2008
    Posts
    189
    inbuilt encryption? What is that?

  14. #14
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Have a look in Tools - Security. Have a read up on Encrypt/Decrypt Database and see if it might help you.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  15. #15
    Join Date
    Apr 2008
    Posts
    189
    But the table contents is read-able by any user that has the "password" of the database.

    I want to make the data on the tables not read-able to all the users (just me).

Posting Permissions

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