Access 2k database keeps changing security permissions

[Tim Chmielewski]

I have a an Access 2000 database that I have given read & write permissions
to the IUSR & IWAM users on my machine (for a web application), but every
time I open the database directly, it loses the permissions for those
users.

Anyone know how this happens?

Thanks.

--
GIT Groupie : http://gitgroupie.timchuma.com
The Twits Give Me the Shits : http://twitsgivemetheshits.timchuma.com
My Photos : http://photos.timchuma.com
Hong Kong Movie Reviews: http://hkmovies.timchuma.com

[Trevor Best]

Tim Chmielewski wrote:

I have a an Access 2000 database that I have given read & write permissions
to the IUSR & IWAM users on my machine (for a web application), but every
time I open the database directly, it loses the permissions for those
users.

Anyone know how this happens?

Thanks.

Do you have "Compact on Close" set? Compacting the database will
re-create the file, probably without the permissions.

--
Error reading sig - A)bort R)etry I)nfluence with large hammer

[Michael \(michka\) Kaplan [MS]]

Yep, see http://trigeminal.com/usenet/usenet028.asp for a bit on the compact
issue.
--
MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.
"Trevor Best" <nospam@localhost> wrote in message
news:40***********************@auth.uk.news.easyne t.net...

Tim Chmielewski wrote:

I have a an Access 2000 database that I have given read & write permissions to the IUSR & IWAM users on my machine (for a web application), but every time I open the database directly, it loses the permissions for those
users.

Anyone know how this happens?

Thanks.

Do you have "Compact on Close" set? Compacting the database will
re-create the file, probably without the permissions.

--
Error reading sig - A)bort R)etry I)nfluence with large hammer