Linked .csv File Locking

Access 2003 problem

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.

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.

Is there any way to force MS Access to play nice with Excel concerning
multiple users of a read-only .csv file?
--
Senior WebFOCUS Programmer
.

Relevant Pages

  • Re: Linked .csv File Locking
    ... I have a daily automated job that creates multiple .csv files on a UNIX box, ... There are many users opening and linking to these files via Excel and MS ... multiple users of a read-only .csv file? ...
    (microsoft.public.access.security)
  • Re: Linked .csv File Locking
    ... I have a daily automated job that creates multiple .csv files on a UNIX box, ... There are many users opening and linking to these files via Excel and MS ...
    (microsoft.public.access.security)
  • Re: Code looping through files new line
    ... Why not let your excel code open the original CSV files, ... Otto and I have talking this morning and here are some clarifications about ... Dim fso As Object, fl As Object ...
    (microsoft.public.excel.programming)
  • Re: With excel 2003 could open .csv file but not in excel 2007.
    ... I didn't know that you were using code to open your .csv files. ... And even though re-registering excel won't help your code, ... Function RowCountYX(ReferenceCell As String, RowOffset As Integer, ColOffset ... Dim Blank As Boolean ...
    (microsoft.public.excel.programming)
  • Re: Excel loading CSV problem
    ... We were surprised by the change in functionality after the upgrade. ... Excel has treated 1-31 and 1-23 as dates for as long as I can remember through ... TIW opens for me in 2003 when I open a *.csv file renamed to *.txt ... You might try changing the extension on the CSV files to *.TXT ...
    (microsoft.public.excel)