Re: Linked .csv File Locking

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

  • Automate MSAccess from Windows .Net app
    ... then open MSAccess and open a secured Access ... the app is already open and opening the secured app. ... the MSAccess app but I can't get the API calls to work in .Net ...
    (microsoft.public.dotnet.general)
  • Re: Automate MSAccess from Windows .Net app
    ... First of all, if possible, I'd avoid automate Access app: ... then open MSAccess and open a secured Access ...
    (microsoft.public.dotnet.general)
  • Re: ADO query to Access not working, no errors
    ... I have an MSAccess query object already in an MSAccess database. ... I can run the query from the VB app, ... You want to run that Query object from a VB app using ADO? ...
    (microsoft.public.vb.database.ado)
Loading