Home | Advertising Info75 USERS CURRENTLY ONLINE   
   Site Search Contact Us Tuesday, August 20, 2019  
 
 


 
ASPProtect
User Management Application with web based screens that allow you to manage users.
www.ASPProtect.com
 
ASPBanner
Banner Rotation system. Advertisers can monitor online statistical reports via their web browsers.
www.ASPBanner.com
 
ASP Photo Gallery
Upload an unlimited amount of albums. Set up categories.Image resizing thumbnail creation.
www.ASPPhotoGallery.com
 
ASPClassifieds
Classifieds system. Set up categories. Users can register themselves. Supports picture uploads.
www.ASPClassifieds.com



DISCUSSION ARCHIVES
 



We didn't realize
the site was so popular.

Other Stuff
 

 
 
vbscript active server pages ASP vbscript SQL database informix oracle SQL Server Perl CGI Delphi PHP source code code sample samples program CJWSoft ASPProtect ASPBanner ASPClassifieds



(Advanced)  (Components)  (Database)  (General)  (Vbscript)




ASPProtect

 
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




 

   Active Server Pages Rule The World
Contact Us  
All artwork, design & content contained in this site are Copyright 1998 - 2019 PowerASP.com and Christopher J. Williams
Banner ads ,other site logos, etc are copyright of their respective companies.
STATS Unless otherwise noted - All Rights Reserved.

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 www.aspclassifieds.com, www.powerasp.com,www.cjwsoft.com,www.aspphotogallery.com,www.codewanker.com,www.aspprotect.com,www.aspbanner.com