By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,506 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

access user tracking

P: 2
hi,

is there a way to track which users are on an access DB?
what i'm trying to do is kind of like an employee time-clock/tracker, so that when employees log in to the access DB or (more likely) when they click on a "clock in" button in the DB, the DB stores them as "in" and they can change their status to "out" or "on break". i need this to work in such a way that all of the employees can see who is "in" at any given time, but only the employee can change his own status. i know it's possible to create a little form in access for doing this, but i'm not so experienced with access, and it would be much easier if i didn't have to. i know there are a lot of similar things for sale, but i want something that can work within our current DB.

thanks
Jan 31 '08 #1
Share this Question
Share on Google+
2 Replies


MindBender77
100+
P: 234
hi,

is there a way to track which users are on an access DB?
what i'm trying to do is kind of like an employee time-clock/tracker, so that when employees log in to the access DB or (more likely) when they click on a "clock in" button in the DB, the DB stores them as "in" and they can change their status to "out" or "on break". i need this to work in such a way that all of the employees can see who is "in" at any given time, but only the employee can change his own status. i know it's possible to create a little form in access for doing this, but i'm not so experienced with access, and it would be much easier if i didn't have to. i know there are a lot of similar things for sale, but i want something that can work within our current DB.

thanks
I designed something similar to what your inquiring about. I ran into issues when multiple users were updating records at the same time on the same table.

JS
Jan 31 '08 #2

P: 2
i don't think that ill be an issue at the moment we really only need this for about 12 of the employees and they all keep different times.
Jan 31 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.