Is there a way for LIMITED Access user in WIN XP to use a VB.NET Front-end to MS Access database?

From: raymartin (anonymous_at_discussions.microsoft.com)
Date: 02/20/04


Date: Thu, 19 Feb 2004 15:06:05 -0800

I have an access 2000 database running under WIN XP. There is no password on the database. I have a VB.NET application that connects using "ADMIN" and no password. All of the users of this computer that have ADMIN level security under WIn XP can use the application fine. I have one user that has LIMITED XP Security priveleges, but if they attempt to use the VB.NET application the .NET framework throws an exception with the message that this user does not have permission to the database - even though they are using an application that connects using ADMIN and no password.

There are two different program. One simply hosts a Crystal Report against the database. This works fine!!!
The other allows for updates to the tables. This is the one with the errors. It apepars that either WIN XP or .NET is "adding" some kind of restriction that grants the user with LIMITED access only READ-ONLY rights to the Database?

How can I allow the LIMITED user to run the application?



Relevant Pages

  • Re: Is there a way for LIMITED Access user in WIN XP to use a VB.NET Front-end to MS Access database
    ... The other allows for updates to the tables. ... It apepars that either WIN XP or .NET is "adding" some kind of restriction that grants the user with LIMITED access only READ-ONLY rights to the Database? ... How can I allow the LIMITED user to run the application? ... the limited user will need create, read, update and delete access to this folder. ...
    (microsoft.public.dotnet.security)
  • Re: how to move location of default database???? plz!
    ... fine, cool about the database, it probably amounts to how much tagging one ... updates - i woulda rolled them all back. ... No recent version of Windows does ... well when you have less than about 50MB to 100MB of free space. ...
    (microsoft.public.windowsmedia.player)
  • Re: Update Sql Server 2000 database from the HP3000
    ... collects those updates via ODBC every 10 or so seconds. ... essentially update the SQL database at the same time as the main ... Authorised and regulated by the Financial Services Authority. ...
    (comp.sys.hp.mpe)
  • Re: The right database for the job?
    ... Note that "many updates ... > the programmer that have to fix somebody elses code and/or database ... > devices under its control, it connects to a central "DB server" program ...
    (comp.databases)
  • Re: Disk transfers
    ... database software rather than in the application itself) is to capture the change in a relatively small update record in a log - which can be supported effectively in a relatively small amount of NVRAM if performance is important, rather than throwing GB of NVRAM at a generic disk write-back cache, and which in any event can effectively batch many such updates into a single log write if they occur very close to each other - and then later perform the eventual on-disk structural updates lazily, in the background, and possibly in bulk. ... though I'm not sure how the latter would vary all that much (unless you're just referring to the difference between disk and NVRAM performance). ...
    (comp.arch)