I installed samba on an Intel based Server running Red Hat 5.2. I can access files on the shares I created but I run into a problem accessing a database program written in MS Access. It seems that only one person at a time can open the database. I get an error of "File is already in use" . What are the optimal settings for accessing MS Access in a multi-user application? Thanks for your help!!! Gabriel Velasquez Inter-IntraNet Communications http://www.riorico.net
On Wed, Jan 27, 1999 at 01:03:32PM +1100, Gabriel Velasquez wrote:> I installed samba on an Intel based Server running Red Hat 5.2. I can > access files on the shares I created but I run into a problem accessing > a database program written in MS Access. It seems that only one person > at a time can open the database. I get an error of "File is already in > use" . > > What are the optimal settings for accessing MS Access in a multi-user > application?I for things to be "100% save", you would have to use a sql-database on your server, and use ms-access as a frontend. Greetings, Florian Pflug
Hello, At 13.03 27/01/99 +1100, Gabriel Velasquez wrote:>I installed samba on an Intel based Server running Red Hat 5.2. I can >access files on the shares I created but I run into a problem accessing >a database program written in MS Access. It seems that only one person >at a time can open the database. I get an error of "File is already in >use" .Access database are eclusively locked by default. There's an option somewhere under Access that lets you open it shared. This has obviously nothing to do with Samba.>What are the optimal settings for accessing MS Access in a multi-user >application?Oplocks are a must. They can speed up speed by a factor of 10 even under multi-user applications. Anyaway it's not a good idea to use Access databases for more than few users. There are reliability issue in this situation. Also this has nothing to do with Samba. Bye! Sbragion Denis InfoTecna Tel, Fax: +39 039 2324054 URL: http://space.tin.it/internet/dsbragio
At 13:42 27/01/99 +1100, you wrote:>> a database program written in MS Access. It seems that only one person >> at a time can open the database. I get an error of "File is already in >> use" . >> >> What are the optimal settings for accessing MS Access in a multi-user >> application? >I for things to be "100% save", you would have to use a sql-database on your >server, and use ms-access as a frontend. >I sugest PostgreSQL. See http://www.postgresql.org Good look Roberto ------------------------------------------------------------------ Eng. Roberto Jo?o Lopes Garcia E-mail: roberto@mha.com.br F. 55 11 848 9906 FAX 55 11 848 9955 MHA Engenharia Ltda E-mail: mha@mha.com.br WWW: http://www.mha.com.br Av Maria Coelho Aguiar, 215 Bloco D 2 Andar Centro Empresarial de Sao Paulo Sao Paulo - BRASIL - 05805 000 -------------------------------------------------------------------