Hello Mark, On Fri, 14 Mar 2003 14:04:42 -0800 GMT (15/03/03, 05:04 +0700 GMT), Mark Wieder wrote:
TF>> network. I prefer to lock them completely rather than for write access TF>> only. Mind you, if someone opens a file, it will be open for less than TF>> a second (to be vague), because once the data is in his RAM, the file TF>> will be closed again while he still sees it on his screen as long as TF>> he wants. > Hmmm. I never lock files on reads. Maybe I should revisit this some > time. It's a good point, just to be safe. It depends on the user base. If you have 1000 users who have to access a large database very often, you might not want to lock the entire file when anybody reads, but you might want to only lock records. If you have 4 users, accessing different smaller databases infrequently on a LAN at home, complete locking should pose no delays. > I've got a multiuser MSAccess database for a nonprofit I work with > that supports simultaneous writes by multiple users into a single > backend database. Mind you, MSAccess has its own quaint way of > defining record-locking (sheesh - don't get me started on Access and > semaphores or we'll find trout flying), but I do take issue with the > above. ;-) TF>> I wasn't just babbling about, I studied this stuff > My condolences on having had to put up with an entire CS master's > program <grin>. LOL! Just reading a 65-page document on how my proposal for the MSc project to look like - and I haven't even thought about a title or subject yet. "File locking" maybe? <g< (f'up2tbot) > I can usually rely on your expertise in your postings, Thanks, same to you. > which is why your blanket generalization above got under my skin. > No, you weren't babbling, but it's simply not true (and misleading > in terms of the original question) that simultaneous file accesses > *will* cause "loss of data integrity, corruption, or loss of data". I generalised and oversimplified. Point taken. I think this has been clarified in the meantime. -- Cheers, Thomas. Moderator der deutschen The Bat! Beginner Liste. Mit einem Kostuemball kann man keine Tore schiessen. Message reply created with The Bat! 1.63 Beta/5 under Chinese Windows 98 4.10 Build 2222 A using an AMD Athlon K7 1.2GHz, 128MB RAM ________________________________________________ Current version is 1.62 | "Using TBUDL" information: http://www.silverstones.com/thebat/TBUDLInfo.html
