Ms Access database security

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Prasu TKP
    New Member
    • Mar 2008
    • 1

    Ms Access database security

    I have developed an Access Application and given to the pople to work through 'Share folder'. There are six people using every day. I have disabled the byepass key also. Very recently one peson copy this application and down loaded to another Access Database. Security wise it is serius Issue. Please let me know how to prevent download Access objects to other database.
  • sierra7
    Recognized Expert Contributor
    • Sep 2007
    • 446

    #2
    Hi
    In this context what do you mean by Access Objects?

    Specifically, what caused the security problem? Was is it the copying of Forms (or parts of) or Data Tables?

    Have you split your database into Back-end and Front-end?

    For a secure system, the data should be split off and located in a hidden folder on the server. The Front-end needs to be linked to it (while it's UN-hidden)

    You should un-check everything in Tools > Startup, nominate a start-up form and you may want to design a custom toolbar (not essential). By disabling 'Allow By Pass' you will stop user access to the Database Window, and therefore access to the data tables (which could be copied & pasted)

    The Front-end should be saved an an .MDE file and not left as an .MDB. This way you can stop users seeing, modifying or stealing your code.

    You should read the sections on Security within Help or an Access manual.

    S7

    Comment

    Working...