Have you ever considered getting away from Access and using MSDE instead? I could never get more than about 5 users using and Access database concurrently without running into locking problems.
-----Original Message----- From: HouseDad [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 8:19 AM To: [EMAIL PROTECTED] Subject: [vbhelp] Re: db access again. My two cents: I deal with crucial data entry applications, which is basically what you are doing. You are updating a database with crucial data. You are using a Access database. This is what I do. Update the database every transaction. If the power goes out, you have lost no data that has been written to the database, worst case scenario you might lose one transaction. How you choose to do this, these other people know much more about, I use DAO DATA1 control, which they have told me repeatedly to stay away from. From what I understand, the biggest difference between what I do and ADO is that with ADO you cannot create a new database file. I don't think this is a problem for you. [C] '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.738 / Virus Database: 492 - Release Date: 8/16/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.738 / Virus Database: 492 - Release Date: 8/16/2004 ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
