"Joost" <jo********@gmail.comwrote
Hi...would please help me, how to protect my
database, i donot want anyboy else changing such
as queries, forms, reports i made. I have
already set the security level but i am still doubt.
Thanks much yr help.
Convert your database in an MDE file. (Tools-Database
Utilties make .MDE file.)
MDE does nothing to protect tables NOR queries.
Further, we have had reliable reports that there is third-party software
available that will re-generate a usable .MDB from an .MDE -- something long
thought to be impossible.
Still, the combination of Access' security and compiling to .MDE is as good
security as you can get for Access and the Jet DB engine. Be sure to
download the Access Security FAQ from Microsoft site, and study it
carefully -- miss one step and you can end up with a "secured" database that
is so insecure that anyone can log in, or "so secure" that even you cannot
log in.
Larry Linson
Microsoft Office Access MVP