MsAccess necessary permission error message # 3033

  • Thread starter Thread starter Guest
  • Start date Start date
Great instructions!! Thanks!! In the RPCAccess folder there are many mdb
files, including RPCdatabase 10.28.05(the defunct db), and also several other
RPC database's with other backup dates, and the original "RPC database". The
only mdw is called RPC.MDW.
 
Well now you have me wondering. I thought before that the 10.28.05 in the
filename was a bit strange.

Do you know, or can you find out what these files are? I would think that
you'd use the original RPC database on a day to day basis, and that it
periodically is backed up - and that's what the date is about. However, can
you verify that?

*IF* I'm right then your shortcut target needs to say...
"C:\Program Files\Microsoft Office\Office10\msaccess.exe"
"\\CALLROOM\RPC\RPCaccess\RPCDatabase.mdb" /wrkgrp
"\\CALLROOM\RPC\RPCaccess\RPC.mdw"
 
Upon a review of the thread, I think my assumption may be wrong. Perhaps
the 10.28.05 isn't a backup but the latest version of the mdb. If that's
the case then your target needs to be
"C:\Program Files\Microsoft Office\Office10\msaccess.exe"
"\\CALLROOM\RPC\RPCaccess\RPCDatabase10.28.05.mdb" /wrkgrp
"\\CALLROOM\RPC\RPCaccess\RPC.mdw"
 
You are correct that the 10.28.05 is the latest copy of the database. We had
another problem with a previous version and I had to make that one (which was
previously a backup) the current version. This was back in October
(obviously from the date you can tell that) and we hadn't had any real
problems till now. So I need to cut and paste this into the target section
of the shortcut to the RPCDatabase 10.28.05. Is that right?
 
Yes, put what I posted below into the target. You'll need to modify
everyone's shortcut.

And please post back if it works!
 
I feel like we're soooo close, but I copied the whole path into the target
for the shortcut, and it gives me an error message that says:
Can't find the database file
"\\CALLROOM\RPC\RPCAccess\RPCDatabase10.28.05.mdb."
Makse sure you have entered the correct path and file name.

I did it twice just to make sure I hadn't messed it up the first time.

Now what? I must have given you something incorrectly. What can I go back
and double check.
 
I see a dot (at the end of mdb) in that error message that shouldn't be
there. Does the target have a dot there?
 
I have gone through all of these scenarios and am getting a little confused
on how to fix my issue. I attempted to remove my warning concerning security
and, somehow, removed my access to my own database. This is on a single
computer with no other usesers. Here's the error that I get when I attempt
to log in:

You do not have the necessary permissions to use the 'C:\Documents and
Settings\Shawn Knapp.Bennett-INDIANA\My Documents\Call Logs\Call Logs
2003.mdb' object. Have your system administrator or the person who created
this object establish the appropriate permissions for you.

When I click help it gives me the "Error 3033".

I make a back-up once a week and now my computer will not open my back-up
database.

I've tried re-directing the Workgroup Administrator to the above path, which
is where the file is, but I'm not getting anywhere. I also found my Target
to my shortcut and it's directed to the right file, I think.

Can you help?

Elis1974 said:
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
Click to expand...
 
Shawn said:
I have gone through all of these scenarios and am getting a little
confused on how to fix my issue. I attempted to remove my warning
concerning security and, somehow, removed my access to my own
database.
Click to expand...

What did you do exactly? Do you mean you removed security? What steps did
you take?
This is on a single computer with no other usesers.
Here's the error that I get when I attempt to log in:

You do not have the necessary permissions to use the 'C:\Documents and
Settings\Shawn Knapp.Bennett-INDIANA\My Documents\Call Logs\Call Logs
2003.mdb' object. Have your system administrator or the person who
created this object establish the appropriate permissions for you.
Click to expand...

How are you opening the database? Is there a desktop shortcut? What is in
the target of the shortcut?
 
I will try to remember the steps that I took. I know that I went into
Tools>Security. From there I'm afraid I don't remember exactly what I do.
As I mentioned, I typically rely on my back-ups, but I think that I've
removed my name from the list of accounts somehow.

I have a shortcut that I use to open. I also tried opening it directly from
the folder, but the same thing happened. From the shortcut I went into
properties and clicked on "Find Target...". It took me directly to
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS(application). I opened
that, but got afraid of making more mistakes.

Thank you for your quick response. Very impressive.
 
Joan,
I need to give you an update on my database. I've gained access again!
PRAISE THE LORD.

I saw on one of your (many) blogs to replace the security .MDW files. Well,
I grabbed my back-up and re-installed it. It works. It's obvious that I
removed my acces in this file somehow.

Thank you for your help.
 
I am having two problems with security in access 2007 at this point. 1. I do
not see how to find the tools, security option to find out which workgroup
file I am associated with, and 2. When I modify the target in the shortcut, I
am unable to get all three of the components in there...

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE"
"C:\BladeRunner\BladeRunner.mdb" "C:\BladeRunner\Security.mdw"

It seems that the last path is not fitting in there or something, as I get a
message that says that access does not like something in the command line...I
have removed quotes around the second two paths, and tried a number of
things, but am still locked out.

Appreciate any help on this...I am stuck.
 
Joe G. said:
"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE"
"C:\BladeRunner\BladeRunner.mdb" "C:\BladeRunner\Security.mdw"

It seems that the last path is not fitting in there or something, as I get a
message that says that access does not like something in the command line...I
have removed quotes around the second two paths, and tried a number of
things, but am still locked out.
Click to expand...

You're missing the /wrkgrp switch. the target should be:

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE"
"C:\BladeRunner\BladeRunner.mdb" /wrkgrp "C:\BladeRunner\Security.mdw"
 
You're missing the /wrkgrp switch. the target should be:

Is it your impression, this being a "legacy method", that people are
continuing to use the "legacy security" of ULS, whereas for any new product
ULS has been abandoned by MS?

It is not that I'm getting at you in any way. I disagreed with the
obsolescence of ULS, along with most. I still do not know what is intended to
replace it. But future-looking suggests MS advises it should be replaced?
Now!!!

Chris
 
Chris Mills said:
Is it your impression, this being a "legacy method", that people are
continuing to use the "legacy security" of ULS, whereas for any new product
ULS has been abandoned by MS?

It is not that I'm getting at you in any way. I disagreed with the
obsolescence of ULS, along with most. I still do not know what is intended to
replace it. But future-looking suggests MS advises it should be replaced?
Now!!!
Click to expand...

As you know Chris, security in Access was never secure, (nor could it be in any desktop database product).

I believe the recommendation is that if you require security, you use a server-based system - SQL Server (either the full product or even the free Express version).

My disappointment is that they got rid of 'security' in Access. It may not have been secure, but it served a useful purpose in setting up a navigation system based on username. Now you have to roll your own. There are some samples at

http://www.pdtltd.co.uk/pdtl/Access2007/Access 2007 vPPC.pdf
and
http://www.utteraccess.com/forums/s...373275&page=1&view=collapsed&sb=5&o=&fpart=1I

I understand why they had to deal with the issue as it didn't meet the bar for security, however no one said they had to call it security. They could have kept the functionality and called it something else.
 
Hello there.
I have a similar problem only... slightly harder.

The database file I'm trying to open was created (and, apparently, secured) on this colleague's PC. Then the hard disk was formatted and a fresh installation was performed. I guess you can see where my problem lies... I am unable to find the name of the .mwd file that was used :-(

On my PC, the default System.mwd file is being used. I tried editing the properties of a shortcut I created on my desktop, as per your instructions. However, not knowing the 'original' .mwd, I cannot get anywhere.

At the moment the shortcut's target field reads:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Documents and Settings\Administrator\Επιφάνεια εργασίας\Καταστήματα.mdb" /wrkgrp "C:\Documents and Settings\Administrator\Application Data\Microsoft\Access\System.mdw"

I've bolded the unknown .mdw filename. My question is, obviously: is there a way to discover the .mdw filename that a specific database was secured with?

Thank you for your help!
 
Back
Top