Using A Form as a Front End For Restricted Table Fields

[Theman]

I have a data base that will have several different departments posting to various fields. I do not want dept A to post in fields designated for dept B etc. I don't really want to use the work administrator function. I thought maybe using a form for each group that is password protected and only contains the fields they need to see which would feed into the same table. Can anyone advise as to the best way to do this? Thanks.

 

[Louise]

If you don't want to get involved in Db security then you can make separate interfaces for each department.

Create a separate backend and only link the tables appropriate for each of your front end interfaces. This will mean that different departments will need to have their own tables (except for common lookup tables etc).

You could have each of the front ends in their own folders on your network and only the dept that should be using that particular front end can have access to that folder. Of course the backend will need to be in a separate folder again and accessible to all.

 

[Theman]

Thanks for the reply. Does this mean I need to build the separate forms with Visual Basic and link the specific fields to the corresponding ones in the Access data base?