Re: Access 2007 Technical Questions

Rather than repeating the inline stuff, I just started up a new clean reply.

When I said validation rules, I didn't mean the fields that you thought of,
but rather validation rules as in rules that I have setup for the data to be
met, which are done via events, not the Validation Rule/Text fields.

It's obvious that you don't see the issue that I have, and nor will you see
the fact that even though I know how to do all three things (reset, help,
and back out) without command buttons within Access, I do have users that
barely even know how to operate a computer and only will do things of what
they see, which is one of the things that I hear from way too many big shot
IT people saying "Oh, it's only training." Even though you would think it's
really easy, I have faced resistance from the very individuals that doesn't
know much about computer systems to such a degree, I had to go just the
opposite of what the IT people had said as training isn't going to knock out
that resistance. As far as supervisors and superintendents are concerned,
who is going to fire a machinist for not knowing much about computer systems
when their primary responsibility is to run the machine, and get the job
done. They are only required to to report their production, which doesn't
take much, but yet, you would be surprised by how much they seem to question
things at times, so while I admire the fact that it wouldn't seem to be
necessary for these features in Access, it's this very reason why I see such
need.

As far as going to SQL Server, those 8 different BE DBs are in regards to at
work, but given what I faced there, it's obvoiusly the SQL Server isn't
going to happen and I don't have that call either. I would in a heart beat
for a business type environment, but not for a home type environment. For
home, I would only have 1, maybe 2 BE DB(s).

Normalization: Hrmmm, what can I say. I take my stuff all the way through
the NF5 level, which many disagree with me taking it to that extent, but I
do see of circumstances as to why to take it all the way through the NF5
level rather than stopping at the strict NF3 level. Also, remember, when
you are combining certain things, you not only have to be able to take it up
the line to the grouped level, but you also must be able to take it back
down to the individual level, thus where NF4 and NF5 comes into play. This
web site explains it better and with examples.
http://www.utexas.edu/its/windows/database/datamodeling/rm/rm8.html

--
Ronald R. Dodge, Jr.
Production Statistician/Programmer
Master MOUS 2000


.