Protected and unprotected data in the same form

[acarruth]

Hi there, here is what I am trying to do:

I need to do a single form with 2 tabs.. the first tab is public information for an account, and the second is private info, such as credit card numbers etc.

The first tab is accessible by anyone, but the second tab is supposed to be accessible by entering a password.

Is there a way that I can do this? Even if I split up the data into two tables, one with public and one with private (no read permissions for normal user), a normal user cannot open the table because the 2nd tab potentially utilizes private data..

Is there a a way around this without having to have 2 separate forms?

Or alternatively, is there a way to limit what a normal user can see in a particular table? The normal user can't read the form unless he/she has read rights on the table.. hm


Thanks!

Allan

 

[mph1]

You could use in the On Open of the form the .visible function for those fields you don't want seen and some criteria, ie password. Once a password is entered correctly the visibility of those fields can turn to true.

HTH

An investment in knowledge always pays the best dividends.

by Benjamin Franklin

 

[acarruth]

Thanks for the quick response..

I actually tried that, and that works.. however, couldn't the normal user just go into the actual table to see the protected information?

 

[mph1]

You would need to have some type of security.

1. make your own tool bar, thus not allowing anyone to close out to a table. The only caution I would mention is to make sure that you are able to get into the db
2. make your db an mde file.



An investment in knowledge always pays the best dividends.

by Benjamin Franklin

 

[acarruth]

Perhaps a way to do it is with a View? I'm not sure how to do a View in Access.. the word 'view' is used so extensively, its hard to find out any information on an actual SQL view..

Anyone know?

Thanks,
Allan