Tags Tags

[Samba] Samba Share - MS Excel when saving “can't access the file, there are several possib le reasons”

July 03rd, 2012 - 12:20 am ET by Gibransyah Fakhri | Report spam
Help Create a new topic
Hello all samba fans.., Long live open source :)
Thanks for the @adminbot for approving me to joining this milis.

Please allow me to ask the question,
I have a weird problem in my samba share. I have one share definition
for 3 client (A,B,C) This share contain some excel file which having a
lot of formula and linked each other.
Client A access the file with libre office (ubuntu), client B access
with WinXP & MS Office 2003, The write and read process working
successfuly on Both of them.

The problem occur when client C accessing the same file with MS Excel
2003 (windows xp). This messagebox appear when he saving the file :

"Microsoft office excel cannot access the \\192.168.1.23\myshare\
There are several possible reasons:

- The File ort path does not exist The file is being used by
another program.
- The workbook you are trying to save has the same name as a
- Currently open workbooks."

I was trying http://support.microsoft.com/kb/291204 but it didnt work.
Below is my share definition :

[brainshare]
comment = brainshare
path = /opt/brainshare/
valid users = @brainshare
force group = brainshare
read only = No
create mask = 0775
veto files = /*.scr/*.eml/thumbs.com/

Help me please... Thanks in advance !
Server: Ubuntu 10.10, Samba version 3.5.4

Thinking out of the box
To unsubscribe from this list go to the following URL and read the
instructions: https://lists.samba.org/mailman/options/samba
email Follow the discussionReplies 3 repliesReplies Make a reply

Similar topics

Replies

#1 Günter Kukkukk
July 03rd, 2012 - 01:00 am ET | Report spam
Am Dienstag, 3. Juli 2012, 06:16:45 schrieb Gibransyah Fakhri:
Hello all samba fans.., Long live open source :)
Thanks for the @adminbot for approving me to joining this milis.

Please allow me to ask the question,
I have a weird problem in my samba share. I have one share definition
for 3 client (A,B,C) This share contain some excel file which having a
lot of formula and linked each other.
Client A access the file with libre office (ubuntu), client B access
with WinXP & MS Office 2003, The write and read process working
successfuly on Both of them.

The problem occur when client C accessing the same file with MS Excel
2003 (windows xp). This messagebox appear when he saving the file :

"Microsoft office excel cannot access the \\192.168.1.23\myshare\
There are several possible reasons:

- The File ort path does not exist The file is being used by
another program.
- The workbook you are trying to save has the same name as a
- Currently open workbooks."

I was trying http://support.microsoft.com/kb/291204 but it didnt work.
Below is my share definition :

[brainshare]
comment = brainshare
path = /opt/brainshare/
valid users = @brainshare
force group = brainshare
read only = No
create mask = 0775
veto files = /*.scr/*.eml/thumbs.com/

Help me please... Thanks in advance !
Server: Ubuntu 10.10, Samba version 3.5.4

Thinking out of the box



what does "smbstatus" (run as root) on the samba server show when
all 3 clients have the same file open?

Does this only happen when _all_ 3 clients access that file at the same time?

So, does it work when only B and C (windows xp) clients access that file?

Cheers, Günter
To unsubscribe from this list go to the following URL and read the
instructions: https://lists.samba.org/mailman/options/samba
Replies Reply to this message
#2 Daniel Müller
July 03rd, 2012 - 02:20 am ET | Report spam
Hi,

Try this

directory mask'70
force directory mode'70
create mask = 2770
force create mode'70
force security mode'70
force directory security mode'70
force group= yourgroup

Give the directory the sticky bit for the group

Good Luck
Daniel

EDV Daniel Müller

Leitung EDV
Tropenklinik Paul-Lechler-Krankenhaus
Paul-Lechler-Str. 24
72076 Tübingen

Tel.: 07071/206-463, Fax: 07071/206-499
eMail:
Internet: www.tropenklinik.de
Von: [mailto:] Im
Auftrag von Günter Kukkukk
Gesendet: Dienstag, 3. Juli 2012 06:45
An:
Betreff: Re: [Samba] Samba Share - MS Excel when saving “can't access the
file, there are several possible reasons”

Am Dienstag, 3. Juli 2012, 06:16:45 schrieb Gibransyah Fakhri:
Hello all samba fans.., Long live open source :) Thanks for the
@adminbot for approving me to joining this milis.

Please allow me to ask the question,
I have a weird problem in my samba share. I have one share definition
for 3 client (A,B,C) This share contain some excel file which having a
lot of formula and linked each other.
Client A access the file with libre office (ubuntu), client B access
with WinXP & MS Office 2003, The write and read process working
successfuly on Both of them.

The problem occur when client C accessing the same file with MS Excel
2003 (windows xp). This messagebox appear when he saving the file :

"Microsoft office excel cannot access the \\192.168.1.23\myshare\
There are several possible reasons:

- The File ort path does not exist The file is being used by
another program.
- The workbook you are trying to save has the same name as a
- Currently open workbooks."

I was trying http://support.microsoft.com/kb/291204 but it didnt work.
Below is my share definition :

[brainshare]
comment = brainshare
path = /opt/brainshare/
valid users = @brainshare
force group = brainshare
read only = No
create mask = 0775
veto files = /*.scr/*.eml/thumbs.com/

Help me please... Thanks in advance !
Server: Ubuntu 10.10, Samba version 3.5.4

Thinking out of the box



what does "smbstatus" (run as root) on the samba server show when all 3
clients have the same file open?

Does this only happen when _all_ 3 clients access that file at the same
time?

So, does it work when only B and C (windows xp) clients access that file?

Cheers, Günter
To unsubscribe from this list go to the following URL and read the
instructions: https://lists.samba.org/mailman/options/samba

To unsubscribe from this list go to the following URL and read the
instructions: https://lists.samba.org/mailman/options/samba
Replies Reply to this message
#3 Gibransyah Fakhri
July 03rd, 2012 - 05:40 am ET | Report spam
On 3 July 2012 13:11, Daniel Müller wrote:

directory mask'70
force directory mode'70
create mask = 2770
force create mode'70
force security mode'70
force directory security mode'70
force group= yourgroup

Give the directory the sticky bit for the group



Hi Daniel and mueller, firstly thank you for the fast response.

Daniel, You saved my day, it works !.
what happen here, why i must set the sticky bit for each directory ?

This is the funny history about this.
Client A, B, and C share "tangled threads" excel works about 3.4 GB.
They working sequencely,
if client A has finished, then client A will copy all that 3.4 GB to
client B and client C notebook with a flash disk xD.
as well client B and C, they doing that carousel ritual each day. :))

Finally we create samba file sharing to change their ritual. :)

Now, i'm worried about the virus issue which someday can infecting the
file, "windows client here".
Is samba is the correct way to solve a problem like this ?

Mmm.. actually, we also have a 2nd scenario to convert their ritual to
revision control using git.
cheers,

Thinking out of the box
To unsubscribe from this list go to the following URL and read the
instructions: https://lists.samba.org/mailman/options/samba
email Follow the discussion Replies Reply to this message
Help Create a new topicReplies Make a reply
Search Make your own search