Lock a table, can it be done

[BUmed]

OK I know that you are never to allow people access to tables. So just to get it out of the way my boss want to do his own quires and I told him not to but.... In order to minimize potential harm is there a way to lock a table so the data can't be changed? Thanks for the help

[jeffstl]

OK I know that you are never to allow people access to tables. So just to get it out of the way my boss want to do his own quires and I told him not to but.... In order to minimize potential harm is there a way to lock a table so the data can't be changed? Thanks for the help

Not sure what kind of app you have but you could modify the start up procedures

Go to Tools...Start up

Then you can direct only a app form to pop up and nothing else.

As far as anything else you will have to try to use the permissions system in sync with the users windows login probably, which can get hairy.

Otherwise I would suggest this:
1) Make a list of all likely projected queries needed and make them all now
2) Make open ended querys where you can input parameters even down to the table you would like to query. (This way your sort of building a limited query builder yourself)
3) Make a copy of the database....... ..frequently... .and keep it stored away somewhere.

Access can be a nasty way of distributing data to multiple users because its IS such a powerful tool. I would personally recommend looking into building a front end "query builder" tool, then locking everything down via the start up options

This way the query tool you build will be the only access they have, instead of direct access to the table.

[Megalog]

I have one suggestion to add onto what Jeff said above..
Set the open query 'Recordset Type' set to 'Snapshot', instead of regular dynasets. Then you can dump them to custom forms, etc, with no fear of data being edited.

[BUmed]

Thanx for the help. I was going to build a query input system and then lock every thing else but I just thought there maybe an easer way.