closed database

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • barry hampson
    #1

    closed database

    I know you can do it but don't know how. So how do you close the database to
    prevent any more development or interference from users.
    More to the point if I have passwords that relate to the database - how do
    I unlock it to make it available for development and adaptation again.
    I was tols that startting the database with shift key pressed gave acces
    to toolbars.Howeve r they revert to limited set before database is
    accessible.

    Thanks for any advice

    Bazza


    Tags: None
    • mvivar
      #2
      Re: closed database

      "barry hampson" <barry.hampson@ ntlworld.com> wrote in message news:<AYU4e.142 44$kr.2016@news fe1-gui.ntli.net>.. .[color=blue]
      > I know you can do it but don't know how. So how do you close the database to
      > prevent any more development or interference from users.
      > More to the point if I have passwords that relate to the database - how do
      > I unlock it to make it available for development and adaptation again.
      > I was tols that startting the database with shift key pressed gave acces
      > to toolbars.Howeve r they revert to limited set before database is
      > accessible.
      >
      > Thanks for any advice
      >
      > Bazza[/color]

      Hi Barry:

      First of all I think it is a must to have an mde database for users...
      and tables should be anyway outside in other computer as a server...
      if you don't want to use the security of access which is a little
      complicated but not that terrible you should have your own security
      programed. I have a form on the startup with user and password... if
      user is me, then I have all the toolbars and privileges, if not they
      have their toolbar called usertoolbar...

      I also have for every table a creationdate, createuser, modifieduser
      and modifieddate fields... creationdate is on default now(),
      createuser is same as loged in in the userform which is opened all the
      time but not visible... modifieddate is on the before event ()now and
      modifieduser the same but taken from the userform again...

      tables are hiden... which is like believe in Santa, but you won't do
      it as easy to the users to corrupt your tables... they can't make
      changes to the usertoolbar... so. They can't avoid the userform...
      because on opening event it hides everything but the form... the key
      problem... it is resolved by using mde, linked tables and replicate
      database...

      I hope this helps...

      Mariana Vivar

        Comment

        Previous template Next
        Working...