Re: Newbie: Why don't I have Security on one of my drives?

From: Larry Woods (larry@lwoods.com)
Date: 08/14/02


From: "Larry Woods" <larry@lwoods.com>
Date: Tue, 13 Aug 2002 19:02:43 -0700


I FINALLY got an answer today. If you ask Access to compress your database,
it destroys any additional permissions that were set! UNREAL!

Thanks for your assistance.

Larry Woods

"Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
news:##knZvtQCHA.1648@tkmsftngp08...
> I'm glad my suggestion helped. Unfortunately, I know little about
> Access so I can't help the second issue. The hope the folks in the
> Access newsgroup can help with your problem.
>
>
> Dan Guzman
> SQL Server MVP
>
>
> "Larry Woods" <larry@lwoods.com> wrote in message
> news:#4C$ndtQCHA.2532@tkmsftngp09...
> > You are SO right! Show how LITTLE I know about security.
> >
> > Since I "have you on the line", want to take a shot at this problem
> that I
> > posted on an Access newsgroup.
> >
> > Thanks in advance... Larry Woods
> >
> > ==============================
> > I am using IIS 5.0 on my computer (Windows 2000 Server). I am
> accessing an
> > Access 2000 database. If I go in and do any work on the database
> directly;
> > i.e., open Access 2000 directly, then when I close the database I lose
> the
> > Internet User permission on the database. I reset it manually then
> > everything is fine as far as access through ASP pages, for example,
> UNTIL I
> > open the database again using Access 2000 directly. Then, the same
> problem
> > as above. Lose of the Internet User permission. This does NOT happen
> with
> > other file types such as .doc or .txt, therefore I have concluded
> (right or
> > wrong) that it is NOT Windows 2000 Server, but Access that is doing
> this.
> > Also, I have set the option on the file--and on all parent
> folders--that
> > states that permission inheritance is to be invoked.
> >
> > Where/what do I change to get Access (?) to quit doing this!?!
> >
> > Thanks.
> >
> > Larry Woods
> >
> >
> > =============================================
> > "Dan Guzman" <danguzman@nospam-earthlink.net> wrote in message
> > news:u7KqBQtQCHA.4248@tkmsftngp08...
> > > Perhaps the E drive is not formatted as NTFS.
> > >
> > >
> > > Hope this helps.
> > >
> > > Dan Guzman
> > > SQL Server MVP
> > >
> > > -----------------------
> > > SQL FAQ links (courtesy Neil Pike):
> > >
> > > http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
> > > http://www.sqlserverfaq.com
> > > http://www.mssqlserver.com/faq
> > > -----------------------
> > >
> > > "Larry Woods" <larry@lwoods.com> wrote in message
> > > news:ujToSDtQCHA.2736@tkmsftngp12...
> > > > I have three drives: C,D,E. C and D show a 'Security' tab when I
> go
> > > to
> > > > drive properties. E does not. What do I have to do to get
> security
> > > on the
> > > > E drive?
> > > >
> > > > Thanks.
> > > >
> > > > Larry Woods
> > > >
> > > >
> > >
> > >
> >
> >
>
>



Relevant Pages

  • Re: code access security
    ... Error 1 CREATE ASSEMBLY for assembly 'GmsSqlClr' failed because assembly ... owner has EXTERNAL ACCESS ASSEMBLY permission and the database has the ... make sure the database owner is mapped to the correct login on ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: low permission cannot convert from A97 to A2000/2003
    ... Delete is a separate permission. ... You need open exclusive permission on the database to ... > The admin user has full privileges. ... > as we wont be importing those files from them, and the contractor will be ...
    (microsoft.public.access.conversion)
  • Re: low permission cannot convert from A97 to A2000/2003
    ... Delete is a separate permission. ... You need open exclusive permission on the database to ... > The admin user has full privileges. ... > as we wont be importing those files from them, and the contractor will be ...
    (microsoft.public.access.security)
  • Re: Windows Power User SQL
    ... The guest user must have connect permission in master and tempdb. ... When I run from the master database for example testing against user bill ...
    (microsoft.public.sqlserver.security)
  • Could not Lock File error
    ... >I'm trying to share an access database with an entire ... >modifying this file with FULL PERMISSION on the parent ... >or not AND ONLY allowing one person to modify it's ... It's called an .LDB file, ...
    (microsoft.public.access.security)