access to edit form but not change form

[rrupp]

How do you set it up so users can edit information in a form but not change
the form design? Sorry, new users, using Access 2003 so I'm sure this is
easy but not figuring it out.

Any help would be appreciated.

Thanks.

 

[Gina Whipp]

rrupp,

If your users are that savvy, I would suggest distributing an mde. However,
if the database is not split this could be a pain to update. Is your
database split?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[rrupp]

No the Database is not split. I could split it if that's easier?

 

[Gina Whipp]

rrupp,

Split... you say users which implies more then one so in order to avoid all
the OTHER issues that can come from sharing a sinbgle database... Split
First, ask questions later! But before you split follow these steps...

1. Make a back-up
2. Make a BACK-UP
3. Read this
http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm
4. Review steps 1 and 2
5. Split you database.
6. When you are all done come back and lets' talk about your options for
protecting you forms and data.

I'll be waiting...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[rrupp]

Thanks Gina! I have read the articles and will work on splitting the
database. Again, thank you very much!

 

[Gina Whipp]

Your welcome...

Now once you get those tables set up post back so we can begin looking at
security options. I'm on y 6th cup of coffee but no rush! I will be
waiting...

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm