You do not have necessary permissions error...

[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

 

[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!

 

[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!


My apologies that VBA Dabbler's name got included. I copied his post partialy to get the error message.>

 

[VBA Dabbler]

Hi Jodi,

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

 

[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?

 

[Jodi]

It automatically shows me admin login when I go to Security ->User and group
accounts. I cleared password.

 

[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.

 

[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.

 

[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.