Hi,

How do I go about protecting my access database so that..

1) Nobody can edit any forms (reason being so nobody can remove the txt box
that states who developed it, change it to their name and sell it)
2) Nobody can view the VBA code.

Any help would be much appreciated...Thank You...

--


Kind Regards
Blue Bell Trading

+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++

Blue Bell Trading

Nick J wrote:[color=blue]
> Hi,
>
> How do I go about protecting my access database so that..
>
> 1) Nobody can edit any forms (reason being so nobody can remove the txt box
> that states who developed it, change it to their name and sell it)
> 2) Nobody can view the VBA code.
>
> Any help would be much appreciated...Thank You...[/color]

Tools -> Database Utilities -> Make MDE file.

Distribute the MDE file, keep the MDB for yourself (do not get rid of this).

--
This sig left intentionally blank

Thanks..

--


Kind Regards
Blue Bell Trading

+++ WHEN REPLYING PLEASE DO NOT DELETE ANY OF THE TEXT AS WE NEED IT FOR
REFERENCE +++

Blue Bell Trading
"Trevor Best" <nospam@besty.org.uk> wrote in message
news:4224bbbd$0$32605$db0fefd9@news.zen.co.uk...[color=blue]
> Nick J wrote:[color=green]
> > Hi,
> >
> > How do I go about protecting my access database so that..
> >
> > 1) Nobody can edit any forms (reason being so nobody can remove the txt[/color][/color]
box[color=blue][color=green]
> > that states who developed it, change it to their name and sell it)
> > 2) Nobody can view the VBA code.
> >
> > Any help would be much appreciated...Thank You...[/color]
>
> Tools -> Database Utilities -> Make MDE file.
>
> Distribute the MDE file, keep the MDB for yourself (do not get rid of[/color]
this).[color=blue]
>
> --
> This sig left intentionally blank[/color]

- in autoexec
Not F_StartUp() Quit
... StopAllMacros

- In F_StartUp()
- If UCASE(CurrentUser()) = "ADMIN" or your programmer login then
= false
else
= true
endif

- In form / Report on open, check to see if the user is allowed to open

- encrypt the MDB(s)

- make a copy of the program MDB

- make an MDE from the copy of the program MDB

- proper security

more information about security / encrypting data at:
www.feed-zone.com/othrcode/accscht9.zip

John Bickmore


"Trevor Best" <nospam@besty.org.uk> wrote in message
news:4224bbbd$0$32605$db0fefd9@news.zen.co.uk...[color=blue]
> Nick J wrote:[color=green]
> > Hi,
> >
> > How do I go about protecting my access database so that..
> >
> > 1) Nobody can edit any forms (reason being so nobody can remove the txt[/color][/color]
box[color=blue][color=green]
> > that states who developed it, change it to their name and sell it)
> > 2) Nobody can view the VBA code.
> >
> > Any help would be much appreciated...Thank You...[/color]
>
> Tools -> Database Utilities -> Make MDE file.
>
> Distribute the MDE file, keep the MDB for yourself (do not get rid of[/color]
this).[color=blue]
>
> --
> This sig left intentionally blank[/color]