Cam Hua wrote:
Hello,
I need to create an Access database for a computer lab (30 computers).
It will be use to replace the manual students sign in/out each time they
use the lab computer. It will contain: L Name, F Name, Computer number,
Date, Sign in time, and Sign off time. I need to be able to save the
data.
I can think of two options and need recommendation which is the best for
this situation.
1) Create a database to put in one delicated computer so students can
sign on/off the database when they use the computer.
2) Create a database to be installed in a network on all 30 computers so
students can sign on/off at the computer station they are using.
* if option 2 is choosing, what programing code can I do to force
students to log on/off from the computer every time before they can
access the Windows screen (desktop).
Thanks for any help. GREATLY APPRECIATED
Cameron
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
One solution would be to have a program that executes and writes the
login name and date/time to a text file on the network when a person
logs in and when a person logs off.
Then each day you could run an append query to append the names,
login/logoff, and date/time to Access.
You can create the following. Goto Start/Run and enter Command
In Dos, enter
Edit Testing.Bat
then enter the following
Echo Off
Echo %Username%
Echo %Date%
Echo %Time%
Echo On
then save it.
From DOS, enter
Testing
You should see your name and the date and time. This assumes you have a
UserName environment variable
I remember you could generate a Txt file with the DOS command
COPY CON
I forget how close the Txt file with the F6 (required for copy con)
within the batch file. Been a few years...You might want to ask in a
DOS group that can tell you how to generate a text file on the fly with
COPY CON that would hold the above info.
You can then append the text file. Let's say you write the above data
to Single.Txt. You want to append it to Group.Txt. You could create a
batch file that does this
Copy Single.Txt+Group.Txt Total.Txt
Del Group.Txt
Ren Total.Txt Group.Txt
You would want the text file to exist, be appended, on the network.
Now how you can have the batch file execute upon logout...don't know.
Actually, this is something someone in a network newsgroup could help
you out on. In fact, if you talk to the network admin at your site, he
can probably help you on setting up a user log in/out file.
Doing something like this removes the user from the hassle of signing
in. He just needs to log into the network to have this file be created.