vba - Prevent enabling of shift bypass - Access 2010 -


i trying prevent database users being able view linked tables in navigation pane of access 2010 database. have hidden pane , disabled f11 key.

i aware can disable functionality of shift key permits bypass access start-up options per this article.

my question whether possible prevent user re-enabling shift key either within database or remotely via database. if not possible know of next best method can use prevent users viewing tables in navigation pane (i know access isn't secure database it's have in office atm)

thanks

my approach security in access following:

encrypt main database using complex password.

use second database log in encrypted database. second database stores usernames, user salts, , encrypted version of main database password user password. way, no user needs have main password.

then, compile second database, it's harder modify database , print main encryption key.

weaknesses:

  1. revoking access user works if doesn't have backup of login database (or have change encryption key on main database, forcing recreate accounts every user).
  2. the encryption i'm using rc4 (implementation in vb wqw found answer here), isn't strong
  3. a tech savvy user has valid password decompile database , use acquire main database password
  4. if you're not signing databases , enforcing databases signed, might modify or replace weaken security

to go through details much, here implementation.

file metadata: size: 672 kb, sha1 hash: 19a6c756b8d5b0cdcebe505b289062a1bbd94dec

quick manual: on first run prompts main database password, location, first user name , password. after that, can use forms want.

note it's earlier work, , haven't thought sql injection (i use doublequote escaping , ashamed it). however, isn't security risk main database, opens possibility destructive hack (and write access database file can destroy anyway).

it's not compiled , menus aren't hidden, can inspect , modify it. when implementing it, hide menus , compile it.

the database, content, licensed cc sa 3.0


Comments

Popular posts from this blog

neo4j - finding mutual friends in a cypher statement starting with three or more persons -

php - How to remove letter in front of the word laravel -

minify - Minimizing css files -