Recent content by pikachew

Hi I need help to display the time difference in table format. However i have difficulty in using the DateDiff("s", nowdate, olddate) function. My table looks like this: ******************************************** <table> <tr> <td class="data2"></td> <td class="data2"><%=rs("Date")%></td> <td...

Thanks for posting. :)

I think you got the wrong idea. My fault as I didnt elaborate. I buliding a web application in which multiple visitors to my website would often end up tring to update/edit/access the same record at the same time (simultaneously). I am not trying to manually key in data into the database or...

Ic, thanks I do not use Forms though. By the way do u encounter concurrency problems as well? :) If you do , could u care to explain or describe what they are?

My problem now is that very often i have many users trying to update/edit the same record in the DB. I implemented the pessimistic locking strategy in an attempt to try to solve this problem of having one user updating the same record which another user is also trying to update at the same time...

Hi, Thanks for replying The 20 users do suffer sometimes. 255 concurrent users? where did that come from? but i cant fully comprehend what you are trying to say. Could u mind elaborating? As for the locking mechanism, i am using ********************** rs.CursorLocation=adUseServer rs.CursorType...

Hi, Can anyone tell me how to solve the concurrency problem in MS Access in a multi-user enviroment? Or is it best to use Databases like Oracle or MS SQL Server as they are more robust client/server database. I have read from somwhere that It is ok to use MS Access for a mutli-user enviroment...

I have finally managed to syncronized the updating of the tables such that they are all the same. I defined '---- CursorTypeEnum Values ---- Const adOpenForwardOnly = 0 Const adOpenKeyset = 1 Const adOpenDynamic = 2 Const adOpenStatic = 3 '---- LockTypeEnum Values ---- Const adLockReadOnly =...

Can someone kindly give me an idea of how to implement locks? I think there is a way to synchronize the updating of the " rs.Open sSQL,,,adCmdTable " using ADOs like these 'ADO Constants '---- CursorTypeEnum Values ---- Const adOpenForwardOnly = 0 Const adOpenKeyset = 1 Const adOpenDynamic...

Thanks for all the advise people. By the way, i have a single Table that stores all all necessary IDs of the other 6 tables. However, the reason for the other 6 tables is to store other inforamtion like browser names(very long), Operating Systems names ( very long as well)...and other stuff.. I...

Table A updates Variable A's Total while Table B updates Variable B's Total. All 6 Tables have a field name Total however they are the "Total" of different parameters. "Total" is of the datatype Long Integer Very simple.

Thanks for the advise.

In the MS Acess DB Design view, There is a option called "Indexed" under "Indexed", there is a choice of 1)No 2) Yes(Duplicates Ok) 3)Yes (No Duplicates) I have a Field name "Time" in Table "Stats" which is giving me a problem such that i have records that show the same time, which is not...

Yup Pat. I have already apologized.(See previous posts) New to the forum. Wont do it again. Thanks for the advise.

Nope im not the pikachew you know.. Im from Singapore. :) Here is another similar function im using ********************************* function GetIdB(sB) sUserID = Request("UserID") sSQL = "SELECT WsID, WsName, Total, UserID FROM WinSize WHERE UserID = '"&sUserID&"' AND WsName = '" & sName...