Access 97 Security Question

[Andy]

I created a form which is tied to a database table. The
database and form are in the same file.

How can I secure the database table to not allow any
updates?

The form is just a frontend query to the database. I tried
using the password protection but after logging in using
the password, the database is open to updates.

Is there way to lock the database as read only or hide?

I would appreciate any help on this.

Thanks,
Andy

 

[Rick]

Tie the form to a query. Make sure they can't edit the query or get
around it.

If I understand it correctly, you would have to take away their table access
so they could ot simply open the table. In order for them to still run the
query, you must change the query properties to Run Permissions = Owner's.

Rick

 

[Rick]

disregard. Posted to wrong message.

 

[Bob Bonta]

On your front end form, select the form properties to not
allow additions, not allow changes.

-or-

On the form properties, do not allow additions and, for
each field on the form, lock the fields in the properties
window.

Bob