Forms and tables

Hi Graham

Sorry for the delay in answering this question.

In Access you can block access to the actual tables but allow data entry into them via forms

One method is to hide the tables from the users view and to make the relevant forms only data entry forms.

To hide a table from view:

1. Right click on the relevant table and select Properties

2. In the Properties dialog box check the "Hideen" checkbox.

This hides the relevant table from view

To then view hidden objects

1. Select Tools , Options

2. In the Options dialog box, check the "Hidden objects" checkbox. Then click on the OK button.

This will return you back to the database window where you should now be able to see all hidden objects including the hidden tables that you are looking for.

To make a form only useful to enter new data:

1. In the forms design view right click the dot in the top, left hand corner of the form and select Properties

2. In the Properties window, select the Data tab

3. in the Data tab area change "Allow Edits" and "Allow Delitions" to NO leaving only "Allow Additions" as YES.

This way someone using the form will not see the existing data in the table and therefore cannot mess with it.

Hope this helps.

Carlos