RE: FN-FORUM Access 2000 Quickun

date posted 1st October 2002 17:09

You need to define "secure" for me to answer that properly.

User level security is quite hard to implement properly; the Access 97
wizard did not seem to do the job properly when I tried it, so I have
been doing it myself ever since. In fact the Access 97 documentation,
third party books, and M$ white papers did not seem to quite tie up with
reality either, but I have not checked more recent docs. I have not yet
seen an application produced by someone else which does implement the
system properly, so the few supposedly secured third party apps I have
worked on have been very easy to "break" into.

All the non-trivial Access apps I develop include some form of user
level security setup, even if just to protect the design from fiddling
users. I am not aware of it having failed yet. But the removal of VBA
code from the user level scheme in Access 2000 up is a real pain in the
butt. I hope they reverse that change soon!

David Nye
http://dnye.co.uk
Business Systems, Database & Internet Applications Design & Development.
Microsoft SQL Server, Access, ASP & VB Programming.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.385 / Virus Database: 217 - Release Date: 04/09/2002