think I found an Access bug

[Guest]

Hallo Microsoft Access Professionals,

I hope you read this message. By the way, it’s really horrible to navigate
through the labyrinth of you God damned difficult Microsoft website, to
(hopefully) find a place where to post this message and to sign in just to
give you this hint. :-(((

OK, let’s go ahead. The following happens to Access 2000 as well as to
Access 2003 Professional Edition.

I’ve got a data base (lets’s call it X.mdb) on computer A, wich is connected
to computer B by means of a net (Microsoft Windows network). Both computers
have installed Windows XP Home SP2, file system NTFS. X.mdb is located on A
in a non-admin user account. It is shared for full network access. Operating
system and Access are in Spanish.

Also computer B (from a non-admin user account as well) needs to get access
to our database X.mdb (which is on A). That’s why the ACL of X.mdb is
complemented with the ACE of the “user group NETWORK†which in turn needs and
gets Full Control. Thus computer B can also get access to X.mdb without any
problems.
(It’s all the same whether I change the ACL by means of cacls or fajo
http://www.fajo.de/portal/index.php?lang=en&option=com_frontpage&Itemid=1)

After opening X.mdb everything remains fine, also the ACL remains the same.
After closing X.mdb however ACE “user group NETWORK†is erased from the ACL
and thus computer B cannot get anymore access to X.mdb.

The reason is that I used the option 'Compact on Close' for X.mdb. After
deselecting this option the problem disappeared and the ACL isn’t manipulated
any loger when closing X.mdb.

IMVHO this seems to be a bug rather than a feature. I hope I could help you
with this message. And please make it (much) easier to report such bugs!

Regards,
Andreas


----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-9397-03483035bc73&dg=microsoft.public.access

 

[Patrice]

IMO expected behavior. It's likely that compact on close actually creates a
new file (to avoid possibly loosing the file if things goes wrong while
compacting). As such this new file doesn't have any more the ACL that were
on the previous file.

Not sure, but it's perhaps considered best generally to put ACLs on
directories as this way this is done by inheritance instead of having to
handle permissions on a file by file basis...

 

[Van T. Dinh]

See the Microsoft Knowledge Base for explanation:

http://support.microsoft.com/kb/295234

 

[Guest]

Thanks Van,

I assure you I had searched before the MS Knowledge Base as well as Google.
But as keyword for this search I used ACL or Access Control List instead of
NTFS permissions. Who could know that keyword? Thus I thought I had to do
with a topic completely unknown so far.

Andreas

 

[Van T. Dinh]

NTFS: New Technology File System

This comes out with Windows NT quite a few years ago. Windows 2000
(internally Windows NT 5) & later (???) also use NTFS as the preferred file
system instead of FAT or FAT32.