Re: Allowing read only and full access to a database
Originally posted by drop_a_beat
We're having a few issues with a database here....
we need to set our database to allow certain users read only and others full write access to it! (using access2000 across the company server if that helps!)
any help would be greatly apreciated
thanks in advance!
Run the user level security wizard from the tools/security menu.
This will set up security similar to WinNT
WARNING DO THIS ON A TEST DB FIRST TO GET A GOOD IDEA OF HOW IT WORKS. IT IS NOT STRAIGHT FORWARD AND THERE IS NO HELP. ONCE THE DB IS SECURED IT IS VERY DIFICULT TO UNSECURE IT.