Re: Sign-In type Access Application

"SludgeQuake" <SludgeQuake@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5B558F9F-0074-4432-B9D4-0B1F279E1EC9@xxxxxxxxxxxxxxxx
> Very new to Access.
> Is there a way to simulate a log-in process in access? We currently log in
> to our PCs using group log-ins. (log in names are our general job titles,
> operator, supervisor, TCA, etc.) So it won't help to reference the
> application user name.
> An ideal function would automatically log out at shift change times (6 AM,
> 2
> PM, and 10 PM) to avoid operators "riding" the log-in of the previous
> shift.
> I'm working on an e-log for tracking events at our plant.
> The form used currently has a cbo for employee ID (though he would only
> see
> his name). If he were somehow logged in, ideally with a password, then
> that
> would be one less entry (and one less chance for mishap).
> I'm hoping someone can give me a reference for this type of application,
> unless there's a relatively simple approach.
> Thanks,
> Sludge

User-level security is a built-in function in Access that would suit your
needs by the sound of it. The downside is that there's a steep learning
curve and plenty of scope for mistakes. If you do opt for ULS then start by
following the steps in the MS FAQ (link on my web site) on a COPY of your
database (always use a copy in case you lock yourself out).

If you want to log users out automatically then this is something that you'd
have to code into your app yourself. It is possible, I've done it myself.

HTH - Keith.
www.keithwilby.com


.

Loading