Introduce Security

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a time management application. There are main users who have access
to everything via links to the data file, and ordinary users who can only add
input. This is done using a run time version of access which triggers an
append query tied to the data file.

Security has not been a problem until now because ordinary users have not
had full versions of Access. This has now changed. Though there is no
confidential information on the data file, there is potential for meddling.

I am seeking advice on the simplest way to prevent access to the data file,
(stored in an mdb file on a server), while not preventing the append queries
from running in the runtime copies, ideally this would not involve
re-distributing the runtime version.

I have some familiarity with access, and a little programming knowledge, but
no experience of Access security.
 
Hi Jim,

Two simple ways compile the mdb to an MDE stops some forms of tinkering, you
can run the full ms access program with the /runtime switch to emulate the
runtime version.

Other than that you can hide the database window, stop users from
LEFT-SHIFTing etc
 
Back
Top