Re: Combo Box as Filter???

"Beatrix J B" <botsug@xxxxxxxxx> wrote in message
news:OKpJIW4hGHA.4848@xxxxxxxxxxxxxxxxxxxxxxx
I plan to make a log on form which opens upon opening application put some
input box for user log on with password and user nomber and a combobox that
looks up to department tbl.

Based from the input in the log on screen ..... this would serve as a basis
for the filter.

Just would have to research how to make a log on screen and pass the values
placed in it ... just starting to program. :-)

I'll just give you the standard warning then that any "home-grown" security like
this is a phenomenal waste of time if any if your users has even a marginal
familiarity with how Access works. A seasoned Access user would be able to
circumvent a logon system like this in a few seconds. If you are just trying to
"guide clerks" it might serve your purposes, but don't go this route if you need
something that provides a real barrier.

Access comes with built in security that while still breakable at least requires
that the "breaker" be willing to spend some money on utility software to do so.
If you need something more "industrial strength" then your data should really be
on a server-based system like SQL Server which has proper security.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • [Full-Disclosure] openssl exploit code
    ... interested in or require timely security information. ... Whos interests are you serving with the private code? ... We are talking about your intellectual property here. ... but also protecting the list so that it can continue to serve a purpose. ...
    (Full-Disclosure)
  • Re: Cgi with GD grap, and displaying graphs
    ... For security purposes, I generally see three categories of files the ... servable files - like web pages and images (serve, never run, never write) ... Even though the server won't directly serve the data files, ... That CGI program is not the only solution. ...
    (perl.beginners)
  • Re: Price gouging?
    ... >> In a time of war when your country's security is threatened, ... >> people serve their country) is absurd even under those conditions. ...
    (comp.sys.mac.advocacy)
  • Re: Rename root
    ... > I thought it would serve to more security in my system... ... quickly find out which users have UID 0. ... Fedora GNU/Linux Core 1 on Athlon CPU kernel 2.4.22-1.2149.nptl ...
    (Fedora)
  • Re: MsAccess necessary permission error message # 3033
    ... Is it your impression, this being a "legacy method", that people are ... ULS has been abandoned by MS? ... As you know Chris, security in Access was never secure,. ... I believe the recommendation is that if you require security, you use a server-based system - SQL Server. ...
    (microsoft.public.access.security)