Design question (1 Viewer)

Hello everybody!


Dear friends,

i've got a database for incoming samples which works as following:
-A unique number and further information are assigned to every sample.
-An automessage is generating (which contains an rtf report with sample's information and a request analysis file as excel) is sending to the person who is charged with the sample.
-Person sends back the request analysis and the supervisor enters the requested analysis in the sample form, for further processing.
I would like, to have the sample's charged person to login the database and fill in the appropriate fields into each sample's form (request analysis) instead of sendng files.
My concern is that i don't want to give full access to everybody because there will be many problems (from accessing to corrypting the file).

-Which is the best solution?
Split the database and give access only in the request anaysis fields?
Create a new database and then trasfer the selected table?

its better to create a new database with linked table to the sample table.
create new form for the sample entry.

Definitely split the database as you are talking about multiple users.
If there are two distinct set of users who will never use the same parts of your database, then having two separate FEs makes sense.
However if there is an chance of overlap now, or in the future, then I would just have one FE and limit access as appropriate.

Thanks both of you!