Access 2002 Help required please......

Simonglencross wrote:
Thanks a million Joan think I get where you are comming from I have
created RWOP's for all or the table and done as you explained I have
not implemented the sercurity yet but will be shortly or would you
recommend doing that now?

Well the RWOP setting is pointless in an unsecured database. In this
setting you have been logged in as 'Admin', so that user is the owner of the
query.

When you implement security, you'll remove all permissions/ownership for the
Admin user, and you'll create a new user to be the owner. You'll want to
change the setting to owner while logged in as that user, and save the
queries.


I noticed that you have recently released a new book what sort of
user is it aimed at?

I did? No wonder I'm so tired! g No I haven't written a book - what did
you see?

--
Joan Wild
Microsoft Access MVP