Just had to share this!

[frozbie]

Hi,

Just had to share this...

Been reading Alison Balter's Mastering Access 2000 Development - fantastic book and highly recommended.

She shares a trick on how to give users access to fields within tables without giving them access to other confidential fields within tables.

User is not granted rights to a table.

A query is created by someone with access rights to the table.

The query uses the non confidential fields. At the very end of the query, in SQL, write:

WITH OWNERACCESS OPTION;

This tells Access that whoever runs the query does so with the Query owners access rights!

Fantastic!

If you want more detail, buy the book!

Frozbie
(Mark)
I got my name back!

 

[Bat17]

but you must have user security set up for it to make any difference

 

[frozbie]

Absolutely!

So, assuming user security has been set so the user has no rights to view the table:

this is a workaround that allows the user access to non confidential fields in that table.

Frozbie

 

[blue_wyvern]

Alison Balter's Book

I agree, it's a great book, worth every pound!! Being fairly new to access programming, I too have found the book of enormous help. Highly recommended!

blue_wyvern

 

[namliam]

Same security "trick" is/can be used in any database format. Example Oracle/SQL server.

 

[snowboarder]

I read a synopsis of the book you recommended on amazon.com. Appears to be for intermediate/advanced users. Do you have a book that you would recommend for beginners? There's so many out there, if you're just starting out they all look good until you start to try and distill the information and discover only later that you're money could have been invested elsewhere. I've already got my first database and query set up using on-line tutorials and this help forum, but a recommendation for a good basic primer would be most appreciated.

Thanks!

 

[frozbie]

I do the same as Pat.

I usually buy books when I need to solve a problem and I can't find it in online forums or just need a general resource that gives lots of info in an area of software I am weak in.

The reason I recommend Alison Balter's book is she takes from beginner to advanced and all the steps in between.

She uses Access wizards when introducing forms and reports and queries which give a good grounding in the Access interface and how to get things done without knowing VBA.

Then shows how to do the same things in VBA using both DAO and ADO (Both of which incidentally are back on the table with Access 2003 (or so I've heard

If you want a book for beginners I would recommend hers - it will answer many of your questions now and still be answering them once you've progressed in your knowledge of access.

Frozbie