Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Location
    Oklahoma City, Oklahoma, USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Security Question (A2K)

    I have written a very basic, NO VBL, program that groups the date for the medication administration in a fairly large county Jail. The program uses a personal information and two medication tables, tied by an autonumber field in the main table and number fields in the two medication fields. The program is kept on my main desktop and I have created links from all the computers used by medical to this file. My problems are probably obvious to experienced users/writers, I cannot control who adds what, or deletes what for that matter. Unfortunately everyone needs to add and often delete things. An inmate may leave the jail or get arrested and added. It happens 50-100 times per day. the file is somewhat large containing about 1000 individuals, about half the jail population, and I need to be able to know who is logged on and what they add or delete. Is it possible. I would also like to split the database so that it runs faster but don't know what to ask or how to do it.

    Bob <img src=/S/grovel.gif border=0 alt=grovel width=31 height=23>

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security Question (A2K)

    Bob,
    <hr>I need to be able to know who is logged on . <hr>
    If you want to know who is on logged in, you will have to read it in the ldb file. In the code librarian of Office 2000 Developer, there is code to do this.

    <hr>I cannot control who adds what, or deletes what for that matter. <hr>
    Access has no triggers to trap modifications on record level. You'll have to secure completely your mdb, then write all the stuff to track every thing what's happening in every object in your mdb. I would suggest to upgrade SQL-Server and his triggers.
    <hr>I would also like to split the database so that it runs faster but don't know what to ask or how to do it.
    <hr>
    You can use the database splitter wizard under Tools|Database Utilities to make a front and back-end mdb

    Hope this help
    Francois

Posting Permissions

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