.mdb's and windows file security - any guru's??

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: mikef (anonymous_at_discussions.microsoft.com)
Date: 09/30/04


Date: Thu, 30 Sep 2004 12:09:47 -0700

I have a customer that is trying to export Access data to
an in-house VB app. Here's the scenario.

The data is collected/input on a PC (2K, non-networked) in
Access. The user is logged in under a special account set
up as Admin to the PC. No Access security is set on the
database.

The Access file is then transferred via flash media to an
office PC (XP, networked). The user then logs in as
him/her self. They are not admins of the office PC's.

Through the VB app, they attempt to import the data and
get an error to the effect "cannot build database file".
According to the developer, they traced it to the fact the
user does not have write permissions to update a T/F field
in the database.

If they login to the destination PC as local admin or give
the user local admin rights, everything works fine. The
problem also does not exist on *gulp* Win98 PC's.

Ideas?



Relevant Pages

  • Re: Launch an app from VB, then close
    ... I am attempting to write a simple VB app in VS 2005 that will copy a secured ... MS Access file from a network drive to the local C drive of a workstation ... VB app to launch the Access file, then close itself and leave the user to ... his database? ...
    (microsoft.public.vstudio.general)
  • Re: Launch an app from VB, then close
    ... MS Access file from a network drive to the local C drive of a workstation ... noticed that the VB app, even tho I've included "Application.Exit" at ... VB app to launch the Access file, then close itself and leave the user to ... his database? ...
    (microsoft.public.vstudio.general)
  • My access database file just keeps getting bigger
    ... I'm using an access file to form a queue between my app and an sql database. ...
    (borland.public.delphi.database.ado)
  • Re: Portable Database Choice
    ... I searched this group quite a bit looking for database alternatives and did find the options below from this search. ... I'm posting this in the hope it can be of use to other developers in a position similar to mine where I needed a low cost alternative to Pocket Access. ... One app requires synchronization between desktop and mobile device, the other requires a push of data from the desktop to mobile. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Portable Database Choice
    ... > database alternatives and did find the options below from this search. ... One app requires ... > push of data from the desktop to mobile. ... > Both of these apps used Pocket Access on the device with Peter Foot's ...
    (microsoft.public.dotnet.framework.compactframework)