Re: Linked .csv File Locking

Tom,

It isn't me that is using this data for a back end... remember that I'm
creating these files for many users spread out all across the U.S.A. I
couldn't possibly police all of their activities concerning how they want to
use this data.

It just seems odd that MS Access doesn't have the capability to hook to a
read-only file... using and keeping it read-only without locking it up.

If I loaded these files into SQL Server Express as "read-only", would that
allow everyone access to them using Excel and MS Access without locking them
up?

--
Senior WebFOCUS Programmer


"Tom van Stiphout" wrote:

On Mon, 14 Apr 2008 09:43:02 -0700, BWS
<BWS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Rather than linking to the files, import them. Either into Access or
into the free SQL Server Express.
-Tom.


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?

.

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 ...
    (microsoft.public.access.security)
  • 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)