- 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]
