<div>
@yo,_bee 

<blockquote>
The only logic that will be bullet proof
</blockquote>
 
I'm actually not looking to be 100% (for the time being), just want to make it difficult to use someone else's credentials.. 
 

<blockquote>
Are you looking to slipstream this hardware into the the current program
</blockquote>
Perhaps I was thinking into such an approach.. 
 
However after viewing Jeff's wise comments above, I better stick out of this.. 
 
@Jeff, 
 
Thanks for opening my eyes on the real security breaches.. 
 
Thanks, 
Ben
</div>

<div>
How about a security camera above the time clock system. Warn the staff that if they are caught defrauding the system they will be sacked. Even a dummy camera may be enough of a deterrent.
</div>

<div>
@akb, 
 
We have already plenty of cameras in place, in addition to LanSchool software. apparently none of these is doing the job.. 
 
@All, 
I thought of something, perhaps checking the IP of the computer from where they did clock in, and compare to the list of IP we have for that user in our list.. 
 
However that will not prevent users from going to someone else's pc and doing it from there. 
 
Any suggestion to solve this? 
 
Thanks, 
Ben
</div>

<div>
Checking the IP address would be a lot of work. 
Especially when the IP/domain might change. 
Besides, ...there should be only specific &quot;dedicated&quot; computers that will allow logins
</div>

<div>
Like I said to be bullet proof you need to implement something that you are unable to reproduce with only the user being present. 
 
BioMeteric is the way. &nbsp;There are systems out there that do not cost much to implement.
</div>

<div>
@Jeff, 

<blockquote>
Checking the IP address would be a lot of work.
</blockquote>
We have the functions below that check for IP and Mac address. 
 

<pre><code class="code-10 nolinks" id="code-20-41489501-1">Public Function getIPAddress() As String
 Dim s As String, i As Integer, strComputer As String
strComputer = &quot;.&quot;
Set objWMIService = GetObject( _
 &quot;winmgmts:\\&quot; &amp; strComputer &amp; &quot;\root\cimv2&quot;)
Set IPConfigSet = objWMIService.ExecQuery(&quot;Select IPAddress from Win32_NetworkAdapterConfiguration &quot;)
For Each IPConfig In IPConfigSet
 If Not IsNull(IPConfig.IPAddress) Then
 For i = LBound(IPConfig.IPAddress) _
 To UBound(IPConfig.IPAddress)
 s = s &amp; &quot; &quot; &amp; IPConfig.IPAddress(i)
 Next
 End If
Next
getIPAddress = s
End Function
</code></pre>
<pre><code class="code-10 nolinks" id="code-20-41489501-2">Public Function getMACAddress(Optional ByVal strComputer As String = &quot;.&quot;) As Variant

 Dim objWMIService As Object
 Dim colItems As Object
 Dim objItem As Object
 Dim vResults As Variant
 Dim i As Long

 Set objWMIService = GetObject(&quot;winmgmts:\\&quot; &amp; strComputer &amp; &quot;\root\cimv2&quot;)
 Set colItems = objWMIService.ExecQuery _
 (&quot;Select * From Win32_NetworkAdapterConfiguration Where IPEnabled = True&quot;)
 
 vResults = Empty
 
 If Not colItems Is Nothing Then
 If colItems.Count &gt; 0 Then
 ReDim vResults(colItems.Count - 1)
 i = 0
 For Each objItem In colItems
 vResults(i) = objItem.MACAddress
 i = i + 1
 Next objItem
 End If
 End If
 
 getMACAddress = vResults
 
End Function
Public Function GetMACAddressSingle()

 Dim vMacs As Variant
 Dim vMACAddr As Variant
 
 
 vMacs = getMACAddress
 
 If Not IsEmpty(vMacs) Then

 For Each vMACAddr In vMacs
GetMACAddressSingle = vMACAddr
Exit Function
 Next vMACAddr
 End If
 
End Function
</code></pre>
 
Are you referring it will put too much of stress on the pc? 
 

<blockquote>
Especially when the IP/domain might change
</blockquote>
Right, I guess Mac will be a better idea like Gustav suggested. 
 

<blockquote>
there should be only specific &quot;dedicated&quot; computers that will allow logins
</blockquote>
Why? Will that in some way help us in this case preventing fraud? 
 
@Gustav, 
Yep, your suggestion sounds good &amp;&nbsp;gets us closer to secure the system.. 
 
@yo_bee, 
I hear what you're saying, however I also saw Jeff's concerns about encapsulating the fingerprints in our DB, I doubt our manager will approve it. 
 
Also as mentioned, we are not looking currently to switch system, rather considering options to enhance our system 
 
@All, 
I'm still open for suggestions (including covering up wholes left by prev suggestions), feel welcome to pitch in.. 
 
Thanks, 
Ben
</div>

<div>
I do not think the FP is stored in the Access DB I am pretty sure that is stored on the device. 
Using that as the Key to unlock and send your record to the DB. 
 
I would recommend that you speak to a sales engineer to validate this. 
 
Since you are looking to switch systems this is a perfect time to look at the software that comes along with these readers.
</div>

<div>
@yo_bee, 
 
We discussed with the manager, and looks like if start going in that direction he would go all the way, meaning purchase a software that keeps all clocking too.. 
 
So for the time being, I guess Gustav's suggestion is the way I would prefer to use, 
 
@All, 
 
However, re Gustav's suggestion above I'm concerned of the following. 
 
Users may realize that the clock ins only work from their pc, and then they will easily beat the system, just ask the friend to go over to their pc and do login.. 
 
Any suggestions to cover this? 
 
Thanks, 
Ben
</div>

<div>
&gt; just ask the friend to go over to their pc and do login ... 
 
He can't - not until the original user has logged out. 
 
/gustav
</div>

<div>
Hi, 
 
Let say someone (Mr A.) is late, they call up a friend and ask them to open his pc and login as Mr A. 
 
Then when comes to log out in the end of the day Mr A has no problem logging off from his pc.. 
 
Thanks, 
Ben
</div>

<div>
Any system where you don't authenticate can be fooled. 
 
/gustav
</div>

<div>
OK experts, 
 
I guess if we want stay with our current app, MAC is the best solution like Gustav had suggested. 
 
Thanks, 
Ben
</div>

<div>
<div class="content wysiwyg-content">
Hi Experts, 
 
I have a program that keeps information on time clock for employees daily schedule. 
 
Each employee enters their name/initials and clicks a button that automatically saves the date/time user came and left. 
 
Now our manager is concerned about fraudulent entries, meaning some employees will ask their friends to open the system and click for them.. 
 
Any idea how I can build in a security logic into the system to prevent this? 
 
P.S. I know there are ready packages in the market with face/fingers recognition etc.. just wonder if we can make up something w/o the need to switch to third party software.
</div>
</div>

Hi Experts,

I have a program that keeps information on time clock for employees daily schedule.

Each employee enters their name/initials and clicks a button that automatically saves the date/time user came and left.

Now our manager is concerned about fraudulent entries, meaning some employees will ask their friends to open the system and click for them..

Any idea how I can build in a security logic into the system to prevent this?

P.S. I know there are ready packages in the market with face/fingers recognition etc.. just wonder if we can make up something w/o the need to switch to third party software.

Looking for Ideas in Time clock program software

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Software is any set of instructions that directs a computer to perform specific tasks or operations. Computer software consists of programs, libraries and related non-executable data (such as documentation). Computer software is non-tangible, contrasted with computer hardware, which is the physical component of computers. Software written in a machine language is known as "machine code". However, in practice, software is usually written in high-level programming languages than machine language. High-level languages are translated into machine language using a compiler or interpreter or a combination of the two.