Re: Linked .csv File Locking

From: Tom van Stiphout <no.spam.tom7744@xxxxxxx>
Date: Mon, 14 Apr 2008 20:26:28 -0700

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?

Follow-Ups:
- Re: Linked .csv File Locking
  - From: BWS

References:
- Linked .csv File Locking
  - From: BWS

Prev by Date: Re: Enforce specific password complexity in user-level security
Next by Date: Re: Linked .csv File Locking
Previous by thread: Linked .csv File Locking
Next by thread: Re: Linked .csv File Locking
Index(es):
- Date
- Thread

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)
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)