Splitting the database

[mohiahmed]

Hi everyone,

I wanted to know whether I could have a back end database with two/three different front-ends linked to the back end?

I have a PA, Secretary and someone who deals with finance. The PA and secretary would need to have the same forms/queries but the person dealing with finance needs access to other quires/reports. I as the manager would need access to everything.

Could I not just hide selected tables/queries/reports that are not needed by individuals? I am finding it difficult to set up login forms as a novice.

Thank you.

[TheShabz]

http://allenbrowne.com/ser-01.html

Then edit each individual front end forms as needed.