|
|
|
|
|
| | |
| |
Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Concurrency - Lock Types, etc. |
|
From: |
reedr |
|
Date: |
5/25/2000 3:45:19 AM |
|
IP: |
209.148.226.45 |
Can someone tell me what issues I should look at when I have users writing to an access db using the addnew - while users are pulling information from the same db/table. I have been running into some weird errors and I am wondering if I have not set the locktypes, cursor types in the right way. What is the correct way to ADD new records to a table while people are hammering it?
i am using:
Set add = Server.CreateObject("ADODB.Recordset")
addSQL = "SELECT tblONE.* FROM tblONE"
add.Open addSQL, DataConn, 1, 3
add.addnew
add.fields("blah") = blah
add.update
close, etc.
Can people still hammer this table in the db (pull records, etc.) while the above code is running? Can the above code be run multiple machines at the exact same time (write to the same table at the exact same time, etc.)?
Any help is appreciated!
reedr
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
