Home All Groups Group Topic Archive Search About

You do not have necessary permissions error...

Author
1 Jun 2006 8:05 PM
Jodi
"You do not have the necessary permissions to use the <name> object. Have
your system administrator or the person who created this object establish the
appropriate permissions for you. (Error 3033)"

is the error i get when i try to access my database. I was using a table in
this database in my Crystal Report. Since Crystal requested a login and
password information, I tried to set passwords and that did not work. Then I
did clear password, joined workgroup etc but still get above error and cannot
access my database at all. Any help will be apprecaited.

Thanks!


Can someone help?

Regards,

VBA Dabbler

Author
1 Jun 2006 8:11 PM
Jodi
Show quote Hide quote
"Jodi" wrote:

> "You do not have the necessary permissions to use the <name> object. Have
> your system administrator or the person who created this object establish the
> appropriate permissions for you. (Error 3033)"
>
> is the error i get when i try to access my database. I was using a table in
> this database in my Crystal Report. Since Crystal requested a login and
> password information, I tried to set passwords and that did not work. Then I
> did clear password, joined workgroup etc but still get above error and cannot
> access my database at all. Any help will be apprecaited.
>
> Thanks!
>
>
> >
Author
1 Jun 2006 8:14 PM
Jodi
Show quote Hide quote
"Jodi" wrote:

> "You do not have the necessary permissions to use the <name> object. Have
> your system administrator or the person who created this object establish the
> appropriate permissions for you. (Error 3033)"
>
> is the error i get when i try to access my database. I was using a table in
> this database in my Crystal Report. Since Crystal requested a login and
> password information, I tried to set passwords and that did not work. Then I
> did clear password, joined workgroup etc but still get above error and cannot
> access my database at all. Any help will be apprecaited.
>
> Thanks!
>
>
>My apologies that VBA Dabbler's name got included. I copied his post partialy to get the error message.>
>>
Author
1 Jun 2006 9:10 PM
VBA Dabbler
Hi Jodi,

What password did you clear?  Was it the password for the 'Admin' username?



Show quoteHide quote
"Jodi" wrote:

> "You do not have the necessary permissions to use the <name> object. Have
> your system administrator or the person who created this object establish the
> appropriate permissions for you. (Error 3033)"
>
> is the error i get when i try to access my database. I was using a table in
> this database in my Crystal Report. Since Crystal requested a login and
> password information, I tried to set passwords and that did not work. Then I
> did clear password, joined workgroup etc but still get above error and cannot
> access my database at all. Any help will be apprecaited.
>
> Thanks!
>
>
> Can someone help?
>
> Regards,
>
> VBA Dabbler
>
Author
5 Jun 2006 1:19 PM
Jodi
It automatically shows me admin login when I go to Security ->User and group
accounts. I cleared password.

Show quoteHide quote
"VBA Dabbler" wrote:

> Hi Jodi,
>
> What password did you clear?  Was it the password for the 'Admin' username?
>
>
>
> "Jodi" wrote:
>
> > "You do not have the necessary permissions to use the <name> object. Have
> > your system administrator or the person who created this object establish the
> > appropriate permissions for you. (Error 3033)"
> >
> > is the error i get when i try to access my database. I was using a table in
> > this database in my Crystal Report. Since Crystal requested a login and
> > password information, I tried to set passwords and that did not work. Then I
> > did clear password, joined workgroup etc but still get above error and cannot
> > access my database at all. Any help will be apprecaited.
> >
> > Thanks!
> >
> >
> > Can someone help?
> >
> > Regards,
> >
> > VBA Dabbler
> >
Author
2 Jun 2006 12:02 AM
Joan Wild
You need to provide more information.  Is/was your mdb secured?  Why was
Crystal asking for a username/password.  What password did you clear?

--
Joan Wild
Microsoft Access MVP

Jodi wrote:
Show quoteHide quote
> "You do not have the necessary permissions to use the <name> object.
> Have your system administrator or the person who created this object
> establish the appropriate permissions for you. (Error 3033)"
>
> is the error i get when i try to access my database. I was using a
> table in this database in my Crystal Report. Since Crystal requested
> a login and password information, I tried to set passwords and that
> did not work. Then I did clear password, joined workgroup etc but
> still get above error and cannot access my database at all. Any help
> will be apprecaited.
>
> Thanks!
>
>
> Can someone help?
>
> Regards,
>
> VBA Dabbler
Author
5 Jun 2006 1:28 PM
Jodi
I am new to security in Access and haven't worked with ti much so I don't
understand the question of mdb/secured. I was the only person using it. In
Crystal Reports when you have a 'managed' environment i.e within the Crystal
framework, you have to add the reports to their repository. When you add, you
store the login info for reach report so you are not prompted for logon
informaton. Even though the Access database had no logon information, it was
requesting. This is how I got into this mess. I cleared the admin after I saw
that setting it did not help in Crystal. It was still prompting.

Show quoteHide quote
"Joan Wild" wrote:

> You need to provide more information.  Is/was your mdb secured?  Why was
> Crystal asking for a username/password.  What password did you clear?
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Jodi wrote:
> > "You do not have the necessary permissions to use the <name> object.
> > Have your system administrator or the person who created this object
> > establish the appropriate permissions for you. (Error 3033)"
> >
> > is the error i get when i try to access my database. I was using a
> > table in this database in my Crystal Report. Since Crystal requested
> > a login and password information, I tried to set passwords and that
> > did not work. Then I did clear password, joined workgroup etc but
> > still get above error and cannot access my database at all. Any help
> > will be apprecaited.
> >
> > Thanks!
> >
> >
> > Can someone help?
> >
> > Regards,
> >
> > VBA Dabbler
>
>
>
Author
5 Jun 2006 1:43 PM
Joan Wild
This sounds to me as though it is Crystal Reports asking for a password, not
Access.

Your Access mdb isn't even secured.


--
Joan Wild
Microsoft Access MVP

Jodi wrote:
Show quoteHide quote
> I am new to security in Access and haven't worked with ti much so I
> don't understand the question of mdb/secured. I was the only person
> using it. In Crystal Reports when you have a 'managed' environment
> i.e within the Crystal framework, you have to add the reports to
> their repository. When you add, you store the login info for reach
> report so you are not prompted for logon informaton. Even though the
> Access database had no logon information, it was requesting. This is
> how I got into this mess. I cleared the admin after I saw that
> setting it did not help in Crystal. It was still prompting.
>
> "Joan Wild" wrote:
>
>> You need to provide more information.  Is/was your mdb secured?  Why
>> was Crystal asking for a username/password.  What password did you
>> clear?
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> Jodi wrote:
>>> "You do not have the necessary permissions to use the <name> object.
>>> Have your system administrator or the person who created this object
>>> establish the appropriate permissions for you. (Error 3033)"
>>>
>>> is the error i get when i try to access my database. I was using a
>>> table in this database in my Crystal Report. Since Crystal requested
>>> a login and password information, I tried to set passwords and that
>>> did not work. Then I did clear password, joined workgroup etc but
>>> still get above error and cannot access my database at all. Any help
>>> will be apprecaited.
>>>
>>> Thanks!
>>>
>>>
>>> Can someone help?
>>>
>>> Regards,
>>>
>>> VBA Dabbler
Author
5 Jun 2006 3:48 PM
Jodi
You are right. It requests database logon and password and displays the mdb.
The only database I access in this report is the access one.

Show quoteHide quote
"Joan Wild" wrote:

> This sounds to me as though it is Crystal Reports asking for a password, not
> Access.
>
> Your Access mdb isn't even secured.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> Jodi wrote:
> > I am new to security in Access and haven't worked with ti much so I
> > don't understand the question of mdb/secured. I was the only person
> > using it. In Crystal Reports when you have a 'managed' environment
> > i.e within the Crystal framework, you have to add the reports to
> > their repository. When you add, you store the login info for reach
> > report so you are not prompted for logon informaton. Even though the
> > Access database had no logon information, it was requesting. This is
> > how I got into this mess. I cleared the admin after I saw that
> > setting it did not help in Crystal. It was still prompting.
> >
> > "Joan Wild" wrote:
> >
> >> You need to provide more information.  Is/was your mdb secured?  Why
> >> was Crystal asking for a username/password.  What password did you
> >> clear?
> >>
> >> --
> >> Joan Wild
> >> Microsoft Access MVP
> >>
> >> Jodi wrote:
> >>> "You do not have the necessary permissions to use the <name> object.
> >>> Have your system administrator or the person who created this object
> >>> establish the appropriate permissions for you. (Error 3033)"
> >>>
> >>> is the error i get when i try to access my database. I was using a
> >>> table in this database in my Crystal Report. Since Crystal requested
> >>> a login and password information, I tried to set passwords and that
> >>> did not work. Then I did clear password, joined workgroup etc but
> >>> still get above error and cannot access my database at all. Any help
> >>> will be apprecaited.
> >>>
> >>> Thanks!
> >>>
> >>>
> >>> Can someone help?
> >>>
> >>> Regards,
> >>>
> >>> VBA Dabbler
>
>
>