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.

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" <(E-Mail Removed)> wrote in message
news:5A382392-F323-4D6E-B056-(E-Mail Removed)...
> 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.

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

"Gina Whipp" wrote:

> 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" <(E-Mail Removed)> wrote in message
> news:5A382392-F323-4D6E-B056-(E-Mail Removed)...
> > 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.
>
>
>

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/AlbertKal...plit/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" <(E-Mail Removed)> wrote in message
news:E58D429D-4E5D-4477-A806-(E-Mail Removed)...
> No the Database is not split. I could split it if that's easier?
>
> "Gina Whipp" wrote:
>
>> 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" <(E-Mail Removed)> wrote in message
>> news:5A382392-F323-4D6E-B056-(E-Mail Removed)...
>> > 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.
>>
>>
>>

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

"Gina Whipp" wrote:

> 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/AlbertKal...plit/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" <(E-Mail Removed)> wrote in message
> news:E58D429D-4E5D-4477-A806-(E-Mail Removed)...
> > No the Database is not split. I could split it if that's easier?
> >
> > "Gina Whipp" wrote:
> >
> >> 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" <(E-Mail Removed)> wrote in message
> >> news:5A382392-F323-4D6E-B056-(E-Mail Removed)...
> >> > 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.
> >>
> >>
> >>
>
>
>

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

"rrupp" <(E-Mail Removed)> wrote in message
news:961917BA-8D96-47B1-BEDD-(E-Mail Removed)...
> Thanks Gina! I have read the articles and will work on splitting the
> database. Again, thank you very much!
>
> "Gina Whipp" wrote:
>
>> 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/AlbertKal...plit/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" <(E-Mail Removed)> wrote in message
>> news:E58D429D-4E5D-4477-A806-(E-Mail Removed)...
>> > No the Database is not split. I could split it if that's easier?
>> >
>> > "Gina Whipp" wrote:
>> >
>> >> 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" <(E-Mail Removed)> wrote in message
>> >> news:5A382392-F323-4D6E-B056-(E-Mail Removed)...
>> >> > 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.
>> >>
>> >>
>> >>
>>
>>
>>