Lock fields in table

[SFC Traver]

I have a main table that gets some of it's data from other tables (i.e. Rank,
Work Section, States, etc) using combo or list boxes. How do I lock the "sub"
tables so that users cannot change what I have in these tables?
I know it is probably pretty simple, but I am drawing a blank!
Thanks
SFC T

 

[Jeff Boyce]

It sounds like you/your users might be directly accessing the tables, rather
than working via forms. As long as they have access to the tables, you will
likely only be able to limit them if you implement Access security (see
relevant newsgroup if you decide to take on this challenge - make backups
first!).

Do any of your tables use the "lookup" datatype? If so, check this
newsgroup for recommendations AGAINST doing so.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Vinson]

I have a main table that gets some of it's data from other tables (i.e. Rank,
Work Section, States, etc) using combo or list boxes. How do I lock the "sub"
tables so that users cannot change what I have in these tables?
I know it is probably pretty simple, but I am drawing a blank!
Thanks
SFC T

First off, I'd suggest NOT using table datasheets for data editing or
entry. They are of very limited capability and aren't really designed
for the purpose, Lookup Fields to the contrary notwithstanding.

If you use a Form bound to your table (or a query on your table), with
Combo Boxes bound to these fields, you can set the "Limit to List"
property of each combo to True. The user won't be able to affect the
data in the States or Rank table, just select a value from it.

John W. Vinson[MVP]

 

[SFC Traver]

Sorry, I guess I should have clarified that I was accessing the tables from a
form. For some strange reason, some of my ranks are getting changed. The
limit to list is set to yes. I am using a split database (fe/be) and while I
am making some requested design changes, have only chose to link some of the
be tables to my desktop to speed things up. Could this be the problem?
Thanks!

 

[John Vinson]

Sorry, I guess I should have clarified that I was accessing the tables from a
form. For some strange reason, some of my ranks are getting changed. The
limit to list is set to yes. I am using a split database (fe/be) and while I
am making some requested design changes, have only chose to link some of the
be tables to my desktop to speed things up. Could this be the problem?

What's getting changed? The values in the Ranks table itself (i.e. all
the Colonels have been demoted to Privates, which might not be a bad
thing...)? or in the table to which your form is bound, which might
just be data entry error?

I can't see that having a shortcut to a table on the desktop would do
anything other than perhaps letting someone (inappropriately?) open
and edit the table. The shortcut itself won't change anything in your
tables.

John W. Vinson[MVP]

 

[jahoobob via AccessMonster.com]

If you want users to see specific data in the from but don't want them to
have the ability to change that data you can set the Locked propety of the
field to Yes.

Sorry, I guess I should have clarified that I was accessing the tables from a
form. For some strange reason, some of my ranks are getting changed. The
limit to list is set to yes. I am using a split database (fe/be) and while I
am making some requested design changes, have only chose to link some of the
be tables to my desktop to speed things up. Could this be the problem?
Thanks!
[quoted text clipped - 13 lines]

John W. Vinson[MVP]