Home All Groups Group Topic Archive Search About

access to edit form but not change form

Author
29 Jan 2009 8:07 PM
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.

Author
29 Jan 2009 11:39 PM
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

Show quoteHide quote
"rrupp" <rr***@discussions.microsoft.com> wrote in message
news:5A382392-F323-4D6E-B056-C9F53EE6251A@microsoft.com...
> 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.
Are all your drivers up to date? click for free checkup

Author
30 Jan 2009 12:58 PM
rrupp
No the Database is not split.  I could split it if that's easier?

Show quoteHide quote
"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" <rr***@discussions.microsoft.com> wrote in message
> news:5A382392-F323-4D6E-B056-C9F53EE6251A@microsoft.com...
> > 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.
>
>
>
Author
30 Jan 2009 1:47 PM
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

Show quoteHide quote
"rrupp" <rr***@discussions.microsoft.com> wrote in message
news:E58D429D-4E5D-4477-A806-EC60CBFEB409@microsoft.com...
> 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" <rr***@discussions.microsoft.com> wrote in message
>> news:5A382392-F323-4D6E-B056-C9F53EE6251A@microsoft.com...
>> > 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.
>>
>>
>>
Author
30 Jan 2009 2:45 PM
rrupp
Thanks Gina!  I have read the articles and will work on splitting the
database.  Again, thank you very much!

Show quoteHide quote
"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/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" <rr***@discussions.microsoft.com> wrote in message
> news:E58D429D-4E5D-4477-A806-EC60CBFEB409@microsoft.com...
> > 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" <rr***@discussions.microsoft.com> wrote in message
> >> news:5A382392-F323-4D6E-B056-C9F53EE6251A@microsoft.com...
> >> > 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.
> >>
> >>
> >>
>
>
>
Author
30 Jan 2009 6:09 PM
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

Show quoteHide quote
"rrupp" <rr***@discussions.microsoft.com> wrote in message
news:961917BA-8D96-47B1-BEDD-69CDB56E4577@microsoft.com...
> 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/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" <rr***@discussions.microsoft.com> wrote in message
>> news:E58D429D-4E5D-4477-A806-EC60CBFEB409@microsoft.com...
>> > 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" <rr***@discussions.microsoft.com> wrote in message
>> >> news:5A382392-F323-4D6E-B056-C9F53EE6251A@microsoft.com...
>> >> > 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.
>> >>
>> >>
>> >>
>>
>>
>>

Bookmark and Share