[thelist] Access database configuration w. concurrent users
Ken Schaefer
ken at adOpenStatic.com
Tue Sep 23 23:42:48 CDT 2003
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "David Slonosky" <david_s at tech-right.biz>
Subject: [thelist] Access database configuration w. concurrent users
: Is there anything that can be done with the configuration of
: IIS 5 and/or Accesss itself to make sure that if multiple writes
: to the database are done concurrently, that the Access database
: comes as close to the ACID test for databases as possible?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
The Jet ODBC drivers and OLEDB providers are single threaded. All requests
will be queued. If you only use atomic actions (single inserts, deletes and
updates), then you won't actually have concurrent activities happening in
the database.
Also, you can enlist a transaction in your ASP page (I assume you're using
ASP since you mentioned IIS...)
HTH
Cheers
Ken
More information about the thelist
mailing list