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

From: Chris Jackson (chrisjATmvpsDOTorgNOSPAM)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 11:09:21 -0500

It could very well be NTFS permissions. If the user doesn't have any rights
on the mdb file, then they won't be able to access the file at all. You
don't get a chance to try your password, because you can't read the file in
the first place. Take a look at your ACLs. 

-- 
Chris Jackson
Software Engineer
Microsoft MVP - Windows Client
Windows XP Associate Expert
-- 
More people read the newsgroups than read my email.
Reply to the newsgroup for a faster response.
(Control-G using Outlook Express)
-- 
"raymartin" <anonymous@discussions.microsoft.com> wrote in message 
news:27630D2C-1569-4B9C-B14F-C86B2C2271C0@microsoft.com...
>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: Access 97 Security issue Cant make a MDE
    ... I am not able to CHANGE these rights. ... Normally I work as both the Owner of the database (and all objects ... we don't reset this table permission after making the mde. ... we give database admin permission to our user group. ...
    (microsoft.public.access.security)
  • Re: Access Security not secure
    ... I created the Administrator and added him to the admin ... database, removed all the rights from the user group. ... access2000 or access2002 that has the default workgroup. ...
    (microsoft.public.access.security)
  • Re: Access Security not secure
    ... new workgroup when I secure it with the wizard all seems ... to work well until I try to access the database on the ... >> I created the Administrator and added him to the admin ... removed all the rights from the user group. ...
    (microsoft.public.access.security)
  • Access 97 Security issue Cant make a MDE
    ... >I am trying to make a MDE of a database. ... Admin user rights to ...
    (microsoft.public.access.security)
  • Re: No CheckOut history ? Urgent...
    ... concerns involving giving access to a VSS database because if they can read ... limited using NTFS permissions to only those who should have permissions to ... Tighter control could be implemented by the ... Admin such that users have no access to the database and the Admin checks ...
    (microsoft.public.vstudio.sourcesafe)