Database security wizard

[Guest]

I have 3 machines sharing the same MS access database.

All 3 machines are often using the database at the same time.

I want to restrict users access to certain parts of the database.

IE I want some to be able to write and read to every object,

Some to only be able to read

And some to only be able to see certain objects.

One of the machines is running MS Office 2003 where the others are using
2002.

Basically I have a LOT of important data that I dont want at risk, at the
moment anyone can edit delete ruin the data and the tables. (and it's scaring
the h*ll outta me

I have tried running the user level security wizard to create user accounts
but it appears to fail every time.


any help or ideas would be much appreciated.

MTIA!

 

[Douglas J. Steele]

Go to http://support.microsoft.com/support/access/content/secfaq.asp and
read the Access Security FAQ (or go to
http://support.microsoft.com/?id=207793 and download it).

Read it several times. Make a copy of your database, and try to follow the
instructions, making sure you don't leave out any steps.

(Don't worry that the KB articles only mention Access 2000: it's exactly the
same for Access 2002 and 2003)