Access database and permissions

My Authorware training pieces send data to an Access database via asp pages.
I test the system in the IIS package in Win XP. All is currently running
well with one exception: the Access database keeps losing two group/user
names.

After selecting the database file, I right click on Properties, then the
security tab. The system runs well when these five group/user names are
visible: Administrators, Internet Guest Account, James (that's me), SYSTEM,
and Users. I give each of these full permissions.

After running a few tests, I find that one test fails. I check the
group/user names for the database and find that Internet Guest Account and
Users have disappeared. The folder containing the database has all of the
five group/user names and none disappear. Any suggestions on why these
group/user names are disappearing?

Thanks.

Jim

Re: Access database and permissions

James_101 wrote:
> My Authorware training pieces send data to an Access database via asp
> pages. I test the system in the IIS package in Win XP. All is
> currently running well with one exception: the Access database keeps
> losing two group/user names.
>
> After selecting the database file, I right click on Properties, then
> the security tab. The system runs well when these five group/user
> names are visible: Administrators, Internet Guest Account, James
> (that's me), SYSTEM, and Users. I give each of these full
> permissions.
>
> After running a few tests, I find that one test fails. I check the
> group/user names for the database and find that Internet Guest
> Account and Users have disappeared. The folder containing the
> database has all of the five group/user names and none disappear.
> Any suggestions on why these group/user names are disappearing?
>
Sometimes, compacting/repairing the database can cause the permissions to
"go away". Granting the permissions at the folder level should prevent this,
however.* I have never explicitly granted permission to the database file
itself. Granting the folder-level permissions has always been sufficient.
Verify that you haven't somehow disallowed inheritable permissions. I don't
know the specifics of this, so you may wish to ask in a newsgroup devoted to
your server's OS.

Try compacting the database. Then reapply the folder-level permissions.
Check the database permissions and make sure it has inherited the
folder-level permissions as it should.

Bob Barrows

* folder-level permissions are required in any case. It is not enough to
grant permissions only to the file - all users of the database must be able
to create, modify and delete the .ldb file in the folder that contains the
..mdb file in order for multi-user activity to occur)

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"