Need a totally READ ONLY database

[BetsyB]

I need to distribute an ACCESS 97 database on CD-Rom. I need to make it
totally read-only and need to make sure that no one can change the
permissions back.
All info found retains admin privileges and depends on changes in
Wrkgadm.exe which just will not work in this situation.

Thanks!

 

[Douglas J. Steele]

The only way you can guarantee it's read-only is to apply Access Security
(and even that's not 100% reliable, as it is possible to crack the
security).

If you only want it to be read-only, there shouldn't be any need to fuss
with wrkgadm.exe: simply remove the Admin id from the Admins group, and put
it in a group that only has read access. Then, regardless what MDW file they
use when connecting, they won't be able to do anything. Make sure you have
an MDW that has an ID for you in case you need to make changes on it later.

 

[Jim Bunton]

I think you also nee to check the default permissions allowed to the 'Users'
group of which Admin is also a member - which can't be revoked.

It would be useful to have more detail about:-
(and even that's not 100% reliable, as it is possible to crack the

security).

Does this demand some hack that crunches through possible Pid's or are ther
'more convenient' methods?!