Hi,

I'm currently in the process of creating a product information database for my company. Contained in this database will be all information relating to each individual product we produce. What I want to create is a database that my colleagues can open to view the information required and be able to search for particular things (product codes,categories, etc) without them being able to modify any of the information contained within the database. I also only want them to see a 'front page' that will display information on 1 product at a time.

To do this, would I create a read only form that my colleagues can access that's linked to the table containing all information or is there a simpler way of doing it?

Hi Craig

The simplest way of doing what you require is by creating a read only form for your colleagues to access.

Although this will prevent your colleagues from changing the data through the form, if they have access to the whole database they could still change the data on the tables.

Therefore, in future, you may need to look at setting up user groups and permissions if you only want them to access the relevant read only forms.

hope this helps

Carlos