Re: Access 97 Security issue Can't make a MDE

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: '69 Camaro (ForwardZERO_SPAM.To.69Camaro_at_Spameater.orgZERO_SPAM)
Date: 12/21/04 

Date: Tue, 21 Dec 2004 09:29:03 -0800

Hi, Keith.

> Whenever I've made an MDE in A97 I've had to set permissions on that
system
> table to get it to work for non-admin users, I assumed this was a bug.

Yes. It is a bug in Access 97. One can read more information on this bug
on this Web page:

http://support.microsoft.com/default.aspx?id=170696

The permissions needed on the MSysModules2 table for non-Admin group users
to open the Access 97 MDE are:

- Read Data
- Read Design
- Update Data
- Insert Data
- Delete Data

So Modify Design or Administer permissions aren't needed for this system
table in order for the non-Admin group users to open the Access 97 MDE,
which is a good thing because even members of the Admin group don't have the
Modify Design or Administer permissions for this table.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

"Keith Wilby" <keith.wilby@AwayWithYerCrap.com> wrote in message
news:Xns95C6AB643FAD2keithwilby@10.15.188.42...
> "'69 Camaro" <ForwardZERO_SPAM.To.69Camaro@Spameater.orgZERO_SPAM> wrote:
>
> > The MSysModules2 table is a system table. No user has either of these
> > permissions on any of the system tables.
>
> Whenever I've made an MDE in A97 I've had to set permissions on that
system
> table to get it to work for non-admin users, I assumed this was a bug.
> It's been a while since I worked with MDEs but I'm pretty sure that was
the
> case.

Relevant Pages

  • Re: PATCH: cdrecord: avoiding scsi device numbering for ide devices
    ... Joerg Schilling wrote: ... > This is of course a kernel bug - but it could be easily fixed. ... Not checking for Write access permissions at this place is a typical mistake ...
    (Linux-Kernel)
  • Re: Run Another X Window as Another User?
    ... Those are all basically console permission issues. ... I found it annoying that the user switching wasn't enabled so I set ... permissions that are setup when a user is granted the console. ... to get some bug reports about my work and things I missed. ...
    (Fedora)
  • Re: Windows 2003 System DSN not found (but User DSN works)
    ... add one of the non-admin users ... it's likely the permissions on the registry keys. ... And make sure to take the non-admin user out of local admins ...
    (microsoft.public.sqlserver.odbc)
  • Re: NTFS inherited permissions bug on W2K
    ... NTFS inherited permissions bug on W2K ... >> Inheritance has always been present in NT. ... >actually copied to the inherited objects' ACLs). ...
    (NT-Bugtraq)
  • Re: /sys/power/state question with sudoers!
    ... as package hibernate has a bug that disallows its useage. ... I go to change the permissions using visido to allow no password, ... It would be nice to post your sudoers file;) ...
    (Debian-User)