|
|
Our Hot Pick: Rising Antivirus 2006 - Certified by TUV & Checkmark! Get 10% discount by entering this coupon code: ONDISCOUNT10
Hello everyone. I'm using A02 on XP. DB is an old A97 that was converted up
to A02. Have a user group with edit rights and they work fine on one form
but not on another. I cannot figure it out! I've checked the permissions
from the DB to tables to queries to forms. If I give someone in the group
admin rights, all is well but I can't do that for everyday permissions. Just
can't figure out what I'm missing. Is there some glitch I'm not aware of?
Must I create a new empty DB and import all my objects? I've been fighting
with this for hours!
Thanks in advance for any advice!
--
Bonnie
|
|
What is the specific error message? That usually tells you the object you
need to focus on.
i.e 'you do not have permission to use xxx object...'
What are the permissions on that object? Does that object have any lookup
fields - (yet another reason to avoid them); users need permission on the
lookup table.
--
Joan Wild
Microsoft Access MVP
Bonnie wrote:
[Quoted Text] > Hello everyone. I'm using A02 on XP. DB is an old A97 that was
> converted up to A02. Have a user group with edit rights and they
> work fine on one form but not on another. I cannot figure it out!
> I've checked the permissions from the DB to tables to queries to
> forms. If I give someone in the group admin rights, all is well but
> I can't do that for everyday permissions. Just can't figure out what
> I'm missing. Is there some glitch I'm not aware of? Must I create a
> new empty DB and import all my objects? I've been fighting with this
> for hours!
>
> Thanks in advance for any advice!
> --
> Bonnie
|
|
Hi Joan,
Thanks very much for your inquiry. I get no message. It simply will not
respond. There is no status bar message or dialog box. I can edit as my
all-powerful self but when I log in as one of the RPSAdm group I can edit
some forms and this one I cannot. I place the mouse in the field and there
is no response to my keystrokes.
P.S. What should I do about the reply I got above from 'bad man'? He
doesn't offend me, he's just showing himself to be a twit. Is there any way
for the PTB's to block foul posting addresses from our newsgroups?
Thanks again!
--
Bonnie
"Joan Wild" wrote:
[Quoted Text] > What is the specific error message? That usually tells you the object you
> need to focus on.
>
> i.e 'you do not have permission to use xxx object...'
>
> What are the permissions on that object? Does that object have any lookup
> fields - (yet another reason to avoid them); users need permission on the
> lookup table.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Bonnie wrote:
> > Hello everyone. I'm using A02 on XP. DB is an old A97 that was
> > converted up to A02. Have a user group with edit rights and they
> > work fine on one form but not on another. I cannot figure it out!
> > I've checked the permissions from the DB to tables to queries to
> > forms. If I give someone in the group admin rights, all is well but
> > I can't do that for everyday permissions. Just can't figure out what
> > I'm missing. Is there some glitch I'm not aware of? Must I create a
> > new empty DB and import all my objects? I've been fighting with this
> > for hours!
> >
> > Thanks in advance for any advice!
> > --
> > Bonnie
>
>
>
|
|
That is odd; I can't think of a reason for this. They obviously have open
permission on the form.
What is the record source for the form? Can you open it directly as one of
the RPSAdm and see any records, or add/edit anything there?
If you can do that, check that there isn't some code behind your form
causing the problem.
As for 'bad man', I suggest you just ignore it.
--
Joan Wild
Microsoft Access MVP
Bonnie wrote:
[Quoted Text] > Hi Joan,
>
> Thanks very much for your inquiry. I get no message. It simply will
> not respond. There is no status bar message or dialog box. I can
> edit as my all-powerful self but when I log in as one of the RPSAdm
> group I can edit some forms and this one I cannot. I place the mouse
> in the field and there is no response to my keystrokes.
>
> P.S. What should I do about the reply I got above from 'bad man'? He
> doesn't offend me, he's just showing himself to be a twit. Is there
> any way for the PTB's to block foul posting addresses from our
> newsgroups?
>
> Thanks again!
> --
> Bonnie
>
>
> "Joan Wild" wrote:
>
>> What is the specific error message? That usually tells you the
>> object you need to focus on.
>>
>> i.e 'you do not have permission to use xxx object...'
>>
>> What are the permissions on that object? Does that object have any
>> lookup fields - (yet another reason to avoid them); users need
>> permission on the lookup table.
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> Bonnie wrote:
>>> Hello everyone. I'm using A02 on XP. DB is an old A97 that was
>>> converted up to A02. Have a user group with edit rights and they
>>> work fine on one form but not on another. I cannot figure it out!
>>> I've checked the permissions from the DB to tables to queries to
>>> forms. If I give someone in the group admin rights, all is well but
>>> I can't do that for everyday permissions. Just can't figure out
>>> what I'm missing. Is there some glitch I'm not aware of? Must I
>>> create a new empty DB and import all my objects? I've been
>>> fighting with this for hours!
>>>
>>> Thanks in advance for any advice!
>>> --
>>> Bonnie
|
|
"Granny Spitz via AccessMonster.com" <u26473[ at ]uwe> wrote in message
news:66afe5e1aa4f0[ at ]uwe...
[Quoted Text] >
> 3) Copy the ISP name and Google for it to find the company's web page.
> Follow the link to the company's web site. Click on the city named as the
> IP
> location to find the company's local office phone number and then scroll
> down
> to find the "Contact Us" email address.
>
Am I missing something here Granny? Does this assume that the offender
works for the ISP?
Thanks.
Keith.
|
|
Keith Wilby wrote:
[Quoted Text] > Does this assume that the offender
> works for the ISP?
The ISP has been assigned IP addresses that provide Internet services for
other computers. An ISP can sell those Internet services to the general
public (like AOL, Comcast, Earthlink, etc.) or the ISP can use those Internet
services in-house, as most companies do. Since the ISP in question is not in
the business of selling Internet services to the public, we can assume that
it's an in-house computer that connects to the proxy server that connected to
the Internet to post those messages. And since these offenses occurred
during regular business hours, it's likely an employee of that business that
has access to the computer used. In any case, it's that company who is
legally responsible for getting to the bottom of this, whether it's a current
employee, the son of a current employee visiting the company's office, or a
hacker causing mischief. They can start with the assumption that it's their
own employee (who else has access to their computer network?) and go from
there.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200609/1
|
|
"Granny Spitz via AccessMonster.com" <u26473[ at ]uwe> wrote in message
news:66d207d3a45d9[ at ]uwe...
[Quoted Text] > Keith Wilby wrote:
>> Does this assume that the offender
>> works for the ISP?
>
> The ISP has been assigned IP addresses that provide Internet services for
> other computers. An ISP can sell those Internet services to the general
> public (like AOL, Comcast, Earthlink, etc.) or the ISP can use those
> Internet
> services in-house, as most companies do. Since the ISP in question is not
> in
> the business of selling Internet services to the public, we can assume
> that
> it's an in-house computer that connects to the proxy server that connected
> to
> the Internet to post those messages. And since these offenses occurred
> during regular business hours, it's likely an employee of that business
> that
> has access to the computer used. In any case, it's that company who is
> legally responsible for getting to the bottom of this, whether it's a
> current
> employee, the son of a current employee visiting the company's office, or
> a
> hacker causing mischief. They can start with the assumption that it's
> their
> own employee (who else has access to their computer network?) and go from
> there.
>
Understood, thanks for the info.
Keith.
|
|
Hi Joan,
I have opened the linked table and the query as one of the administrators
and have the same inability to edit. Have deleted the link and relinked it
(tables are in a backend DB).
Should I try to create a new shell DB and import my objects?
Thanks very much for your help.
--
Bonnie W. Anderson
Cincinnati, OH
"Joan Wild" wrote:
[Quoted Text] > That is odd; I can't think of a reason for this. They obviously have open
> permission on the form.
>
> What is the record source for the form? Can you open it directly as one of
> the RPSAdm and see any records, or add/edit anything there?
>
> If you can do that, check that there isn't some code behind your form
> causing the problem.
>
> As for 'bad man', I suggest you just ignore it.
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Bonnie wrote:
> > Hi Joan,
> >
> > Thanks very much for your inquiry. I get no message. It simply will
> > not respond. There is no status bar message or dialog box. I can
> > edit as my all-powerful self but when I log in as one of the RPSAdm
> > group I can edit some forms and this one I cannot. I place the mouse
> > in the field and there is no response to my keystrokes.
> >
> > P.S. What should I do about the reply I got above from 'bad man'? He
> > doesn't offend me, he's just showing himself to be a twit. Is there
> > any way for the PTB's to block foul posting addresses from our
> > newsgroups?
> >
> > Thanks again!
> > --
> > Bonnie
> >
> >
> > "Joan Wild" wrote:
> >
> >> What is the specific error message? That usually tells you the
> >> object you need to focus on.
> >>
> >> i.e 'you do not have permission to use xxx object...'
> >>
> >> What are the permissions on that object? Does that object have any
> >> lookup fields - (yet another reason to avoid them); users need
> >> permission on the lookup table.
> >>
> >>
> >> --
> >> Joan Wild
> >> Microsoft Access MVP
> >>
> >> Bonnie wrote:
> >>> Hello everyone. I'm using A02 on XP. DB is an old A97 that was
> >>> converted up to A02. Have a user group with edit rights and they
> >>> work fine on one form but not on another. I cannot figure it out!
> >>> I've checked the permissions from the DB to tables to queries to
> >>> forms. If I give someone in the group admin rights, all is well but
> >>> I can't do that for everyday permissions. Just can't figure out
> >>> what I'm missing. Is there some glitch I'm not aware of? Must I
> >>> create a new empty DB and import all my objects? I've been
> >>> fighting with this for hours!
> >>>
> >>> Thanks in advance for any advice!
> >>> --
> >>> Bonnie
>
>
>
|
|
Hi Keith,
Thanks for your efforts to keep the newsgroups 'clean'. And thanks to
'Granny' for the input.
--
Bonnie W. Anderson
Cincinnati, OH
"Keith Wilby" wrote:
[Quoted Text] > "Granny Spitz via AccessMonster.com" <u26473[ at ]uwe> wrote in message
> news:66d207d3a45d9[ at ]uwe...
> > Keith Wilby wrote:
> >> Does this assume that the offender
> >> works for the ISP?
> >
> > The ISP has been assigned IP addresses that provide Internet services for
> > other computers. An ISP can sell those Internet services to the general
> > public (like AOL, Comcast, Earthlink, etc.) or the ISP can use those
> > Internet
> > services in-house, as most companies do. Since the ISP in question is not
> > in
> > the business of selling Internet services to the public, we can assume
> > that
> > it's an in-house computer that connects to the proxy server that connected
> > to
> > the Internet to post those messages. And since these offenses occurred
> > during regular business hours, it's likely an employee of that business
> > that
> > has access to the computer used. In any case, it's that company who is
> > legally responsible for getting to the bottom of this, whether it's a
> > current
> > employee, the son of a current employee visiting the company's office, or
> > a
> > hacker causing mischief. They can start with the assumption that it's
> > their
> > own employee (who else has access to their computer network?) and go from
> > there.
> >
>
> Understood, thanks for the info.
>
> Keith.
>
>
>
|
|
"Bonnie A" <bonnielynnw[ at ]discussions.microsoft.com> wrote in message
news:E118508E-995D-45E8-BAD5-5EE4CA2C773E[ at ]microsoft.com...
[Quoted Text] > Hi Keith,
>
> Thanks for your efforts to keep the newsgroups 'clean'. And thanks to
> 'Granny' for the input.
>
> --
> Bonnie W. Anderson
> Cincinnati, OH
>
I just didn't quite understand Granny's explanation but do now ... I think
;-) I followed my work IP using Granny's link and it returned the correct
provider (CSC) but the location was way out. Having said that I'm sure CSC
would have no problem in tracing me should the need arise (and I sincerely
hope it doesn't).
Keith.
www.keithwilby.com
|
|
Keith Wilby wrote:
[Quoted Text] > I followed my work IP using Granny's link and it returned the correct
> provider (CSC) but the location was way out.
The ISP's themselves are responsible for keeping the public records up-to-
date, and many of them don't. Also, IP addresses are issued in *banks* of IP
addresses assigned to the ISP's. Each bank of IP addresses is registered
with a single geographical location where those IP addresses are to be used,
so your location could be 1,000 miles away from headquarters, and your
company's headquarters location could be registered as your IP address
location, not your physical location.
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200609/1
|
|
That suggests that there is something in the form preventing the edits,
since you can edit the recordsource. check the code behind the form to see
if there is something locking things; also check the properties of the form
(allow edits, etc)
--
Joan Wild
Microsoft Access MVP
Bonnie A wrote:
[Quoted Text] > Hi Joan,
>
> I have opened the linked table and the query as one of the
> administrators and have the same inability to edit. Have deleted the
> link and relinked it (tables are in a backend DB).
>
> Should I try to create a new shell DB and import my objects?
>
> Thanks very much for your help.
> --
> Bonnie W. Anderson
> Cincinnati, OH
>
>
> "Joan Wild" wrote:
>
>> That is odd; I can't think of a reason for this. They obviously
>> have open permission on the form.
>>
>> What is the record source for the form? Can you open it directly as
>> one of the RPSAdm and see any records, or add/edit anything there?
>>
>> If you can do that, check that there isn't some code behind your form
>> causing the problem.
>>
>> As for 'bad man', I suggest you just ignore it.
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> Bonnie wrote:
>>> Hi Joan,
>>>
>>> Thanks very much for your inquiry. I get no message. It simply
>>> will not respond. There is no status bar message or dialog box. I
>>> can edit as my all-powerful self but when I log in as one of the
>>> RPSAdm group I can edit some forms and this one I cannot. I place
>>> the mouse in the field and there is no response to my keystrokes.
>>>
>>> P.S. What should I do about the reply I got above from 'bad man'?
>>> He doesn't offend me, he's just showing himself to be a twit. Is
>>> there any way for the PTB's to block foul posting addresses from our
>>> newsgroups?
>>>
>>> Thanks again!
>>> --
>>> Bonnie
>>>
>>>
>>> "Joan Wild" wrote:
>>>
>>>> What is the specific error message? That usually tells you the
>>>> object you need to focus on.
>>>>
>>>> i.e 'you do not have permission to use xxx object...'
>>>>
>>>> What are the permissions on that object? Does that object have any
>>>> lookup fields - (yet another reason to avoid them); users need
>>>> permission on the lookup table.
>>>>
>>>>
>>>> --
>>>> Joan Wild
>>>> Microsoft Access MVP
>>>>
>>>> Bonnie wrote:
>>>>> Hello everyone. I'm using A02 on XP. DB is an old A97 that was
>>>>> converted up to A02. Have a user group with edit rights and they
>>>>> work fine on one form but not on another. I cannot figure it out!
>>>>> I've checked the permissions from the DB to tables to queries to
>>>>> forms. If I give someone in the group admin rights, all is well
>>>>> but I can't do that for everyday permissions. Just can't figure
>>>>> out what I'm missing. Is there some glitch I'm not aware of?
>>>>> Must I create a new empty DB and import all my objects? I've been
>>>>> fighting with this for hours!
>>>>>
>>>>> Thanks in advance for any advice!
>>>>> --
>>>>> Bonnie
|
|
|