On Sun, Feb 18, 2007 at 10:49:10AM +0200, Uri Even-Chen wrote: > Are you sure? I heard different opinions here. Will the Access > database data get corrupted if the server is not Windows? Can Samba > handle record & table locking in Access? Or can it not?
Unfortunately all I can find by STFW'ing is that: 1. It SHOULD work perfectly. No one ever followed up and said that it did. The people that said it should were Linux "experts" with little or no Windows experience. Take it for what its worth. 2. If you turn on locking, it only allows one user access to the database. No corruption, but no access either. 3. It's not by table, it's by data base (file locking). 4. M/S SQL server does it's own internal record/table/database locking. Bear in mind that Access was designed to be single user. Multiple users are supported by SQL server. Personally, I think there are a lot better ways to introduce open source software to a company. The risk of data loss or corruption is too high and the benefit too low. Geoff. -- Geoffrey S. Mendelson, Jerusalem, Israel [EMAIL PROTECTED] N3OWJ/4X1GM IL Voice: (07)-7424-1667 Fax ONLY: 972-2-648-1443 U.S. Voice: 1-215-821-1838 Visit my 'blog at http://geoffstechno.livejournal.com/ ================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
