B
BWS
I have a daily automated job that creates multiple .csv files on a UNIX box,
and then FTP's these files to a read-only directory on an NT box, stomping on
top of the previous day's files.
There are many users opening and linking to these files via Excel and MS
Access.
I was surprised to learn that MS Access will still lock these .csv files
even though the user only has read-only permission for that directory.
This effectively does two bad things. If a user keeps Access open through
the night, my job fails because the files are locked. Also, there seems to
be more and more contention problems between users of this data, when one of
them is using MS Access.
My suggestion is this...
Modify MS Access so when someone links a file, MS Access interprets the
directory permissions, and if it is read-only, keeps the file unlocked and
accessible.
--
Senior WebFOCUS Programmer
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...5e0bb628f&dg=microsoft.public.access.security
and then FTP's these files to a read-only directory on an NT box, stomping on
top of the previous day's files.
There are many users opening and linking to these files via Excel and MS
Access.
I was surprised to learn that MS Access will still lock these .csv files
even though the user only has read-only permission for that directory.
This effectively does two bad things. If a user keeps Access open through
the night, my job fails because the files are locked. Also, there seems to
be more and more contention problems between users of this data, when one of
them is using MS Access.
My suggestion is this...
Modify MS Access so when someone links a file, MS Access interprets the
directory permissions, and if it is read-only, keeps the file unlocked and
accessible.
--
Senior WebFOCUS Programmer
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...5e0bb628f&dg=microsoft.public.access.security