Access 2002/2003 You don't have the necessary permissions...

[Melanie Morton]

I have read several previous postings and tried the advice without
success.
Shared Access 2002 database written by someone who left the company,
but states she did not add security or create a new workgroup. Access
2002 users have been using database without having to log-in, no error
messages. A new user who has Access 2003 on her PC tried to open the
database and got the "You don't have the necessary permissions..."
error. Since then, all the 2002 users also get the same error. The
2003 user does not have a system.mdw file on her C:/ drive. However,
she has opened other databases without a problem.
Tried using a shortcut to open the database, specifying the
C:\Windows\system32\system.mdw workgroup file, but no success. Can't
find another mdw file in the folder where the database is located.
Any thoughts? Is this a 2002 vs 2003 conflict?

 

[TC]

That's not much information to go on.

- is the db split into a FE/BE structure?

- do they share a single copy (and if so, of what), or do they "share"
it by virtue of each having a seperate copy on their own PC?

- how are they starting the database? double-clicking, or using a
shortcut? If a shortcut, what is the text of that shortcut?

- was the A2k3 user prompted to "convert or open" the database when she
tried to open it?

- what is the exact text of the error they're getting? Are all users
getting exactly the same error?

TC

 

[Melanie Morton]

Thanks for your reply. I got called in after the fact, but this is
what I am told.
No FE/BE - it's one self-contained database located on a shared drive.
They all open the same mdb file by double-clicking it. I have no
indication this is a replicated database.
A2K3 user was not prompted to "convert or open".
All users get the same error message: "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."
However, she says after she clicked OK to the above error message, she
clicked Tools, Security, Macro and set the Security Level to "Low". I
have no idea what this is, since I don't see any such thing in A2K2 -
is this A2K3? Since she was never able to open the database, would
this have had any effect anyway?

 

[TC]

I'm not sure what to suggest for you here.

Re. the message "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."

- If the database HAS NOT been secured: that message should not appear.
It's nothing to do with the macro security level. The macro security
level affects other messages that were added by Access 2003. Those are
all along the lines of, "This database contains macros or VBA code &
will therefore set your house on fire. Click ok to void your insurance
and cause a tornado."

- If the database HAS been secured, someone must have joined all
relevant PCs to the relevant workgroup information file, otherwise they
wouldn't have been able to open the secured database by double-clicking
it; - OR, the database was not secured correctly, thus allowing anyone
to open it by double-clicking it. In either case, I can't see why the
message in question would suddenly start appearing - when it did not
appear before - unless someone has altered the workgroup file, or used
the workgroup administrator program or function to select a different
workgroup file.

I think the next step in trying to solve this, would be to determine
whether the database is or is not meant to be secured, & whether
someone has or has not recently used the workgroup adminmistrator
program or function.

If the user in question has already tried changing the macro security
level - without having any real idea what that does - she might have
fiddled with the workgroup administrator?

HTH,
TC