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?
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?