lock colums in a table

F

flo

I need to lock one of the columns in a table which will be accessed by three
other users in my office, to avoid accidental deleting of date?
 
J

Jeff Boyce

Flo

Are you saying you are giving your users direct access to the table itself?
Don't!

In Access, tables store data, and forms (and reports) display it. Build
forms for users to use to see data. You can set the forms to only allow
reading of data (hence, no deleting).

Regards

Jeff Boyce
<Office/Access MVP>
 
F

flo

Actually, being pretty new to ACCESS, I created a macro in the switchboard to
access the table.
The table consists of districts, the subtable consists of reports which are
filed biweekly. What is an alternative for data input by multiple users,
would I create a form by District and subform for the reports?

I thought the simplest way would be to lock the District column, and allow
users to enter directly into the subform accessing the table through the
swithboard macro.
 
J

Jeff Boyce

Flo

(see comments in-line below)

flo said:
Actually, being pretty new to ACCESS, I created a macro in the switchboard
to
access the table.
Click to expand...

Again, don't let the users see/work directly in the table.
The table consists of districts, the subtable consists of reports which
are
filed biweekly. What is an alternative for data input by multiple users,
would I create a form by District and subform for the reports?
Click to expand...

Perhaps it's semantics, but I don't understand how a table can have
"districts", and a subtable can have reports. Could you describe your
underlying data, and provide an example?
I thought the simplest way would be to lock the District column, and allow
users to enter directly into the subform accessing the table through the
swithboard macro.
Click to expand...

(see above -- don't!)

I'll still recommend that you use a form for data entry/edit.

Regards

Jeff Boyce
<Office/Access MVP>
 
Top