 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / December 2005lock colums in a table
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> >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? 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 > [quoted text clipped - 13 lines] > >three > > other users in my office, to avoid accidental deleting of date? Flo (see comments in-line below) > 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> |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.