Re: Design Protection

From: Marshall Barton (marshbarton_at_wowway.com)
Date: 12/23/04 

Date: Thu, 23 Dec 2004 10:32:32 -0600

Newman wrote:

>I currently have designed an extensive Program using
>access as a platform to host it. The front end requires
>user login and password to access, and the back end
>consist of dozens of MDE databases. The front end is
>also being utilized as an MDE. The MDB of all are stored
>on a remote server which only I the administrator can
>access, and is backed up on CD as well. The database has
>a self-protection i built into it, which detects my log-
>in. If my login is not sensed within the last 72 hours,
>the program ceases to run, and denys all logins, and
>shuts itself down. Only my login can initiate the system
>override and re-activation for the next 72 hour cycle.
>So in other words if i drop dead or get laid off, the
>program is rendered useless. My main concern is someone
>being able to reconstruct the program or rewrite some of
>the macros from an MDE....is it possible if only the MDE
>is available? By the way, all the admin forms, macros,
>etc. are set up to allow run or read only to all users
>but myself. My login only allows design changes even in
>the MDB. Let me know if my protection can be over
>ridden or undone. Thanks

There is no such thing as a system that can not be broken!

However, you are potentially liable to lawsuits for not
meeting contractual agreements. If anyone is paying for the
use of the database, they will be very upset if it stops
working just because you got sick or went on vacation and
could not remotely reactivate the program's timer. If this
program was developed as part of your employment, your
employer also has numerous legal rights to the program and
the data it contains. You really need to have a serious
discussion with your legal advisor before you are sued six
ways from Sunday. 

-- 
Marsh
MVP [MS Access]

Relevant Pages

  • Re: Design protection
    ... Readers have to check other readers' responses in ... set the computer's system date back or create a login account name identical ... The business operations that depend upon your database system ... > consist of dozens of MDE databases. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Design protection
    ... Readers have to check other readers' responses in ... set the computer's system date back or create a login account name identical ... The business operations that depend upon your database system ... > consist of dozens of MDE databases. ...
    (microsoft.public.access.security)
  • Re: Design protection
    ... Readers have to check other readers' responses in ... set the computer's system date back or create a login account name identical ... The business operations that depend upon your database system ... > consist of dozens of MDE databases. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Design Protection
    ... or not) of employment a thorough going over. ... >>>consist of dozens of MDE databases. ... If my login is not sensed within the last 72 ... >>use of the database, they will be very upset if it stops ...
    (microsoft.public.access.modulesdaovba)
  • Re: code execution order
    ... > I am using windows xp and SQL server 2000 as database and trying to ... > veripwd.asp and then redirects to index.asp on successfull login. ... > first it cheks user login name and pwd.. ... In the absence of real code, the only suggestion I can make is to use SQL ...
    (microsoft.public.inetserver.asp.db)
Loading