Bulletproofing database with .mde file

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: John S. Ford, MD (johnsfordNOSPAMmd_at_hotmail.com)
Date: 08/16/04 

Date: Sun, 15 Aug 2004 22:22:05 -0700

I've made an Access 97 application which will be used by multiple users. I
set the start-up properties very restrictively so as not to allow the
database window to be visible, limited short-cuts menus, default menus, etc.
I then created an .mde file as well.

The problem is this: a user can click on my start icon and quickly hit the
shift key which will open the database WITH the database window. The user
doesn't have access to forms, design view, etc. but DOES have the ability to
delete tables and queries.

How can I get around this? is there a way to guarantee that the database
window can't be accessed without using a runtime distribution?

John

Relevant Pages

  • Strange DataBase window format !
    ... functions before opening a User Login Form. ... One of the functions the autoexec executes is to minimize the DataBase ... But when we want to code we allow a bypass key, which is the SHIFT key, ... right and bottom and finally find a small, minimized database window. ...
    (microsoft.public.access.forms)
  • Re: Access/Comcast/Digital Conversion
    ... would affect a database that was not using the internet somehow. ... Database would open but not the database window I meant that the ... According to the directions to solve the missing library reference, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Database Window Missing
    ... There are the open source databases like MySQL - ... You might consider breaking the database apart, separating front end to back end. ... > The database window is missing from my application. ... Horizontal scroll bar returns to extreme ...
    (microsoft.public.access.externaldata)
  • Re: AllowBypassKey
    ... Make sure you are in the main database window. ... Function DisableShiftKeyBypass() As Boolean ... Dim prop As Property ... At the database window, hit Ctrl-G which will open the debug window. ...
    (microsoft.public.access.security)
  • Re: AllowBypassKey
    ... Make sure you are in the main database window. ... Function DisableShiftKeyBypass() As Boolean ... Dim prop As Property ... At the database window, hit Ctrl-G which will open the debug window. ...
    (microsoft.public.access.security)