Search results

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...

To further illustrate the grevious problem that i have at hand. Eaxmple. i have 6 functions Functions A,B,C,D,E,F updating 6 corresponding tables Tables A,B,C,D,E,F Meaning Function A only updates Table A, Function B updates Table B each time my site (written in ASP) is hit by a visitor, all...

I am trying to update about 10 tables each time a visitor visits my site.. however there are often missing counts, meaning the total data in each table are not the same frequently They are supposed to be since all the tables get updated each time. Im using MS Access 2003. Below is an example of...

Hi all, Is there a difference between rs("Fieldname") and rs.Fields("Fieldname") i have always been using rs("Fieldname"), doesnt seem to be giving me a problem. Although for a particular table in which many Tables need to be updated concurrently, there is a loss of data. However for the rest of...

Ok will try to change them and see how it goes from here. Thanks for the advise..will update the results soon. :)

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...