Connecting Tech Pros Worldwide Forums | Help | Site Map

Locking a Database

Chinwan
Guest
 
Posts: n/a
#1: Nov 12 '05
I wrote a database for someone, but I want to lock it somehow that he can
not read all the coding i did, and/or that he can not edit my forms. how is
this possible?

than you

Larry Linson
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Locking a Database


Compile to MDE. That will lock the code and objects with code modules, which
will include Forms. It will not lock down Tables, Queries, or Macros.

If you want that additional level of security, you need to download the
Security FAQ from http://www.microsoft.com/downloads and study it
carefully -- it is not simple but it is doable. If you secure in that
manner, anyone wanting to steal your Queries or Macros would have to spend
US$150 or so for a good password breaking software package, and they still
couldn't get your code, forms, or reports (well, with code and coding skills
they could recreate the look of the forms and reports, but they'd have to
reinvent any code used with them).

Larry Linson
Microsoft Access MVP

"Chinwan" <skullymatjas@yahoo.com> wrote in message
news:87a9070f734e6a1c05d1c6b298a00d64@news.teranew s.com...[color=blue]
> I wrote a database for someone, but I want to lock it somehow that he can
> not read all the coding i did, and/or that he can not edit my forms. how[/color]
is[color=blue]
> this possible?
>
> than you[/color]


Closed Thread