Strange Phenomenon

[pikachew]

Hi all,
Been having this problem for a long time.
Everytime my function is being called, a new tuple gets inserted into Table "Stats" containing the below mentioned data.

sSQL = "SELECT * FROM Stats WHERE UserID = '"&sUserID&"'"
rs.Open sSQL,,,adCmdTable
'Save the data
rs.AddNew
rs("JaID") = lIdJa
rs("JsID") = lIdJs
rs("LanID") = lIdLan
rs("ResID") = lIdRes
rs("WsID") = lIdWs
rs("Date") = Date
rs("Time") = Time
rs("IP") = sIP
rs("UserID") = sUserID
rs.Update

Some of the weird data i got from Table "Stats"
1/25/2005 12:45:59 aaaa bbbb cccc dddd ..... row1
1/25/2005 12:46:24 aaaa bbbb cccc dddd ..... row2
1/25/2005 12:46:29 aaaa bbbb cccc dddd ..... row3
1/25/2005 12:46:35 aaaa bbbb cccc dddd ..... row4
1/25/2005 12:46:40 aaaa bbbb cccc dddd ..... row5
1/25/2005 12:46:40 aaaa bbbb cccc dddd ..... row6
1/25/2005 12:46:40 aaaa bbbb cccc dddd ..... row7
1/25/2005 12:52:51 aaaa bbbb cccc dddd ..... row8

Each time a person click on my site, one tuple will be inserted into the Table "Stats".
The puzzling thing is how is it possible for the time to be the same for row 5,6 & 7.
This happens very often and i have totally no explantion for it. I tried changing the time format, date format, however i always get this.
Please advise.
Thanks a lot

 

[sam77755]

hi there

I cant explain it but can only think of 1 reason... some of your users maybe frantic clicking the button triggering this data entry you set in your table... i would suggest you tak to them and observe how they are using your application

 

[pikachew]

Yup you are right.
I am testing my application now..trying to find out whether the application is able to handle data storage in almost Real Time situations..
It seems to be that once MS Access i subjected to multiple hits on the DB, errors like this will occur. Is there anything i can do, baring from using another DB?
I would like to know whether how many concurrent updates to the tables can MS Access handle... or is there something wrong with my code.
Please advise.
Any thoughts and suggestions will be greatly appreciated.
Thanks again sam77755