Access 97 Security Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andy - 02 Apr 2004 16:40 GMT

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

Reply to this Message

Rick - 02 Apr 2004 16:50 GMT

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

> I created a form which is tied to a database table. The
> database and form are in the same file.
[quoted text clipped - 12 lines]
> Thanks,
> Andy

Reply to this Message

Rick - 02 Apr 2004 16:56 GMT

disregard. Posted to wrong message.

> I created a form which is tied to a database table. The
> database and form are in the same file.
[quoted text clipped - 12 lines]
> Thanks,
> Andy

Reply to this Message

Bob Bonta - 02 Apr 2004 19:21 GMT

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

>-----Original Message-----
>I created a form which is tied to a database table. The
[quoted text clipped - 14 lines]
>Andy
>.

Reply to this Message