Creating a database for multiple users and .....

[sm80]

Hello,

I’m looking to create a database which will be housed on a network and used by multiple users (sometimes at the sane time). I was looking into splitting the database and locate the backend on the network and distribute the frontend to the user.

I only want for the frontend user to be able to insert a new record in the database but not to see any of the existing records in the database.

Is splitting the database the correct way to go and how would I setup the database to prevent frontend users seeing database content?

Does this make sense and is it possible?

Thanks

 

[DCrake]

If the user cannot see the database contents how are they going to know if they have entered the information correctly?

As a matter of interest what is so important that the user does not see what has bveen entered previously?

You can restrict the database to the users own entries. In other words they cannot see what anyone else has added.

 

[sm80]

The entries would need to be confidential so i dont want every user to see other peoples entries

 

[DCrake]

Then in your main data capture table record the name of the person who made the entry. Then on the on open of the database/form apply a filter to that persons records only.