Separate DB for record ADDITION only

[gbrian]

I have a database built for keeping track of candidate and interviews for positions.

I have a form for interviews by candidate--you can add or browse.

I would like to make a copy of this exact form, but with ONLY the ability to ADD interviws and not browse (confidentiality).

What would be the best way to go about this--I first thought access permissions, but I don't like the implementation.

Should I create a separate database and use linked tables? And change the form to an insert only form? (How would I do that?)

I appreciate the replies!!!

 

[PHV]

Have a look at the DataEntry property of the Form object and/or at DataMode:=acFormAdd in the DoCmd.OpenForm call.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[gbrian]

Okay I will take a look. However, if I link the tables the user will be able to browse them, anyhow. How do I get around that?

 

[xyle]

You can create a seperate database and link it like you said. Then go to tools menu, startup and uncheck everything and set a switchboard or the form you want the user to use in the Display/Form page: combo box.

NOTE: Once you save the database like this and close and reopen it, your new database will be stuck like this so make sure you back up your database first before seeing if this is what you want.