lock colums in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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>
 
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.
 
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.

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?

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.

(see above -- don't!)

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

Regards

Jeff Boyce
<Office/Access MVP>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top