Home | Advertising Info6 USERS CURRENTLY ONLINE   
   Site Search Contact Us Thursday, December 12, 2019  

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


We didn't realize
the site was so popular.

Other Stuff

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


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.fields("blah") = blah

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!



   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 what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa 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