Re: Linked .csv File Locking

Never mind... I tested it.

MS Access can lock a linked .csv file even though the file permissions are
set to read-only, and the directory permissions are read-only.

I need Microsoft to chime in here. I think that maybe the NT admins we have
here are missing something important.
--
Senior WebFOCUS Programmer


"BWS" wrote:

Hmmmm... you got me thinking differently about the solution.

I have been coding on a UNIX platform for so long, I completely missed the
fact that these files are loaded to an NT box, who's directory is read-only.
The files themselves are not read-only, so that's why MS Access is able to
lock them.

I think the solution is to have an NT admin create an auto job to delete
these files at 3:00 AM... set my UNIX job to FTP these files to the NT box at
4:00 AM... then have the NT admin create another auto job to set all of these
files to read-only at 3:10 AM.

Please tell me that MS Access can't lock a file who's permissions are set to
read-only.
--
Senior WebFOCUS Programmer


"Tom van Stiphout" wrote:

On Tue, 15 Apr 2008 07:35:01 -0700, BWS
<BWS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

From your OP it wan't clear to me that the users were in different
locations and not under your control. Not knowing more details I can
only offer general suggestions.
I don't know if you are offering this MsAccess app that links to the
daily csv files, or if your user community has written their own apps
and are complaining to you - the data provider - that they can't use
the files multi-user. If the former: write a stronger app that imports
the data like I suggested in first instance. If the latter, offer an
MsAccess db in the ftp download.

-Tom.



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?

.

Relevant Pages

  • Re: access() is a security hole?
    ... >> Perhaps the way to avoid the race is to open the file, lock it, ... > can't tell you that access should have been blocked due to permissions ... > inode returned by the fstatand statare the same makes the race ... > there's no way to securely do this and handle symlinks (because you ...
    (FreeBSD-Security)
  • Re: permission denied - can files be locked in linux?
    ... I understand permissions, but I don't have shell access. ... think PHP can lock files, but I didn't know it affected the filesystem... ... even using the app provided by the hosting company. ...
    (alt.os.linux)
  • server application unavailable
    ... The directory permissions ... permissions to the apllication directory. ... request failure can be found in the application event log of the web server. ... String codeBase, Evidence assemblySecurity, Assembly locationHint, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: error when I unzip
    ... On Sunday 14 October 2007 10:58:43 Hex Star wrote: ... It's permissions are set to root and so a lock symbol shows in the icon to ... "Truth lies within ourselves: it takes no rise from outward things, ...
    (Ubuntu)
  • RE: IIS still vulnerable
    ... definitely lock permissions down on the ntfs level for the iusr ... Set Basic NTFS Permissions for IIS 5.0 ...
    (microsoft.public.inetserver.iis.security)