MsAccess necessary permission error message # 3033

[Guest]

Has anyone ver gotten this message when trying to open an Access database:
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). Please help. This is out of
the blue, and I can't seem to fix it.

 

[Joan Wild]

That message indicates that you are not using the correct workgroup file,
while trying to open the database.

Is this database secured? Do you launch it via a desktop shortcut? What is
the target of that shortcut, if so.
You say it started 'out of the blue', but databases do not implement
security by themselves.

Open Access and go to Tools, Security, Workgroup Administrator and it will
tell you the workgroup file you are joined to by default. Post back with
that path. Also do a search on your computer for *.mdw and post back with
those paths.

 

[Guest]

I was under the impression that the database was secure. I set up the user
names and passwords myself several years ago, and have never gotten this
error message before. This database is on an internal network, where it is
based at one main computer, and then the others can access it by going
through a shortcut on their desktop which is connected to the main computer.
When I open the Access program on my computer, which is not the main
computer, this is the workgroup path I get: C:\Documents and
Settings\eallerellie\Application Data\Microsoft\Access\System.mdw. I tried
to check the workgroup administrator on the main computer and I don't even
have that option. The workgroup administrator does not come up under tools
and security. On my computer, when I search for *.mdw I get the same
workgroup path as above, listed for "system". But when I search the internal
network I get the the following path: M:\RPCaccess, which is the name of the
folder that the database is in on the main computer. As explained above, we
did launch the database from a shortcut, and the target is
"\\CALLROOM\RPC\RPCaccess\RPC Database10.28.05.mdb". I hope some of this
makes sense to you, cause I'm completely confused. I am a nurse, not a
computer person. I just took a few classes and developed this database, and
obviously have no idea what I'm doing Any help would be appreciated.
Thanks, Elisabeth

 

[Joan Wild]

I was under the impression that the database was secure. I set up
the user names and passwords myself several years ago, and have never
gotten this error message before.

OK, that establishes that you are not using the correct workgroup file.
That is why you are getting the error.

This database is on an internal

network, where it is based at one main computer, and then the others
can access it by going through a shortcut on their desktop which is
connected to the main computer. When I open the Access program on my
computer, which is not the main computer, this is the workgroup path
I get: C:\Documents and Settings\eallerellie\Application
Data\Microsoft\Access\System.mdw.

OK, that suggests to me that you are joined by default to the standard
system.mdw that ships with Access.

I tried to check the workgroup

administrator on the main computer and I don't even have that option.

On the main computer, Access is likely an older version (but the default
workgroup on that machine doesn't matter anyway).

The workgroup administrator does not come up under tools and
security. On my computer, when I search for *.mdw I get the same
workgroup path as above, listed for "system". But when I search the
internal network I get the the following path: M:\RPCaccess, which is
the name of the folder that the database is in on the main computer.
As explained above, we did launch the database from a shortcut, and
the target is "\\CALLROOM\RPC\RPCaccess\RPC Database10.28.05.mdb". I
hope some of this makes sense to you, cause I'm completely confused.

That target assumes that you are joined by default to the workgroup file in
M:\RPCaccess and you're not.

You have two choices (the second one being preferred):
Go back into the workgroup administrator on each machine, click on Join, and
browse to the mdw file in M:\RPCaccess.
Or
Modify the shortcut...
"path to msaccess.exe" "\\CALLROOM\RPC\RPCaccess\RPC Database10.28.05.mdb"
/wrkgrp "\\CALLROOM\RPC\RPCaccess\something.mdw"

That is all on one line. You need to check the path to msaccess.exe on your
local machine and substitute accordingly. And also the name of the mdw.

In Access, you are always joined by default to some mdw file. It is used in
all Access sessions. When you secure a mdb, you create a new workgroup
file. Since you can only be joined by default to one workgroup at a time,
you can create a shortcut like the one above to over-ride the default, for
that session.

Normally you don't want to make your secure mdw the default one to use,
because you may have other databases that are not secure, and you don't want
to login for those. Hope that explains it.

 

[Guest]

I have the same problem when I replaced the upgraded PC for the users. So I
just join the workgroup.mdw then all access asking user ID and password. I
don't know how to fix it ---separate only one file using user ID and password
, all other MS access files don't need user ID and PW. Please help.

 

[Joan Wild]

I have the same problem when I replaced the upgraded PC for the
users. So I just join the workgroup.mdw then all access asking user
ID and password. I don't know how to fix it ---separate only one file
using user ID and password , all other MS access files don't need
user ID and PW. Please help.

You need to use the workgroup administrator and join the standard system.mdw
that ships with Access. Then create a desktop shortcut to launch the secure
mdb. The target would look like:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

 

[Guest]

Well, I'm glad that you can identify what's going on. That makes me feel
better. And I greatly appreciate your instructions, however, I have a few
more questions before I start this "fixit job". Please see below questions...
1. How do I modify a shortcut?
2. In reference to this "You need to check the path to msaccess.exe on your

local machine and substitute accordingly. And also the name of the mdw."- how do I do this, and which machine is considered the "local" machine. Is it tha main computer?

I know I probably seem like a moron, and I guess with this I am. Thanks for
you help!

 

[Joan Wild]

Well, I'm glad that you can identify what's going on. That makes me
feel better. And I greatly appreciate your instructions, however, I
have a few more questions before I start this "fixit job". Please
see below questions...
1. How do I modify a shortcut?

Right-click the shortcut, and choose Properties. It'll open to the shortcut
tab and the Target line will be highlighted. Edit that line.

2. In reference to this "You need to check the path to msaccess.exe
on your

'local machine' means your computer (not the main one). If you go to Start,
Search for file and folders, you can type msaccess.exe in the textbox for
'what to search for' - that will find the file and show you the path; it's
likely something like
c:\Program Files\Microsoft Office\Office\...

As for the name of the mdw, you didn't specify in your previous message,
what the name of the file is, just the folder. So look in
CALLROOM\RPC\RPCaccess\ or your M:\RPCaccess folder to find the name of the
file.

 

[Guest]

O.K. Hopefully this will be my last few questions In the shortcut, where I
put in "path to msaccess.exe" "\\CALLROOM\RPC\RPCaccess\RPC
Database10.28.05.mdb"
/wrkgrp "\\CALLROOM\RPC\RPCaccess\something.mdw", I have 2 questions:
1. Do I actually put "path to msaccess.exe", or do I just start with
"\\CALLROOM\RPC...
2. What is the "something" at the end of the path?

Thansk you so much for all your help!! If I can tell any of your superiors
how much I appreciate you, I'd like to.

 

[Douglas J. Steele]

Where it says "path to msaccess.exe", put the path to wherever msaccess.exe
is located on your machine. For example, on my machine that's C:\Program
Files\Microsoft Office.11\OFFICE11\msaccess.exe. Since there are blanks in
that path, it's necessary to enclose it in quotes:

"C:\Program Files\Microsoft Office.11\OFFICE11\msaccess.exe"

The "\\CALLROOM\RPC\RPCaccess\something.mdw" is whatever your workgroup file
(the mdw associated with your application) is actually named.

 

[Guest]

So you're saying that I should go the the shortcut on my desktop and right
click on properties and then under the shortcut tab, where it says Target: I
should type in
"\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
"\\CALLROOM\RPC\RPCaccess\something.mdw", but instead of putting "something"
I should put RPCDatabase10.28.05, which is the name of the database I am
trying to gain access to?

I'm feeling very confused right now. The simpliest way you can explain this
to me would be most helpful. Preterd you're talking to a 5 year old

 

[Joan Wild]

So you're saying that I should go the the shortcut on my desktop and
right click on properties and then under the shortcut tab, where it
says Target: I should type in
"\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
"\\CALLROOM\RPC\RPCaccess\something.mdw", but instead of putting
"something" I should put RPCDatabase10.28.05, which is the name of
the database I am trying to gain access to?

No. Almost, but not quite. In an earlier post, you said when you searched
for *.mdw on the network, it located a mdw file in the
\\CALLROOM\RPC\RPCaccess folder - what is the name of the mdw file it found
in that folder?

Also, when you search your local computer for msaccess.exe, what is the path
that it finds for this file?

 

[Douglas J. Steele]

You must include the the msaccess.exe part. Switches such as /wrkgrp won't
work otherwise

 

[Guest]

1. When I search for *.mdw on the network, (called Callroom), I get a file
called RPC located in the M:\RPCaccess folder.
2. When I search for msaccess.exe on my local hard drive (C) I find nothing.

I'm so confused at this point!!!

 

[Joan Wild]

So the path to your workgroup file is M:\RPCAccess\RPC.mdw, right?

When you search for msaccess.exe, be sure to search all files and folders,
and click on More Advanced Options and check the system folders, and hidden
files and folders, and subfolders. Post back with the path.

 

[Guest]

1. The path to the workgroup file for the defunct database is
M:\RPCAccess\RPCDatabase10.25.05.mdw.

2. On my Hard Drive, when I search for msaccess.exe the path I get is
C:\Program Files\Microsoft Office\Office10

 

[Joan Wild]

Great, we're almost there.

First you shouldn't name the mdw the same as the mdb - they each need to
create an associated ldb file and they can't if they both have the same
name.

I would change the name of the mdw to RPCDatabase.mdw

Now right-click your desktop shortcut and put the following in the target:

"C:\Program Files\Microsoft Office\Office10\msaccess.exe"
"\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
"\\CALLROOM\RPC\RPCaccess\RPCDatabase.mdw"

You will need to modify everyone's shortcut to say this.

 

[Guest]

O.K. Now I'm not so sure that the path to the workgroup file for the defunct
database is actually M:\RPCAccess\RPCDatabase10.25.05.mdw. I guess I sort of
assumed it was, since that's the path I used to follow to get to it. How can
I be sure? And, then how do I change the name of it?

Ughhhh!! I know you'll be as happy to be finished with this as I will!

 

[Joan Wild]

Open My Computer or Windows Explorer and go to the ME:\ drive. Open the
RPCAccess folder. Go to Tools, Folder Options, and then the View tab. In
the Advanced settings list, ensure that 'Hide extensions for known file
types' is unchecked.

Now in that folder what files do you see listed that have a mdw or a mdb
extension?

--
Joan Wild
Microsoft Access MVP

O.K. Now I'm not so sure that the path to the workgroup file for the
defunct
database is actually M:\RPCAccess\RPCDatabase10.25.05.mdw. I guess I sort
of
assumed it was, since that's the path I used to follow to get to it. How
can
I be sure? And, then how do I change the name of it?

Ughhhh!! I know you'll be as happy to be finished with this as I will!

 

[Joan Wild]

That should have been M:\ not ME:\