[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