(Error 3033) You do not have the necessary permissions to use ...

[Guest]

Hi All,

We were sent an Access Database (Access 2002) form our head office on CD and
when we try to open it we receive the following 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. (Error 3033)"

Could somebody please tell me what we have to do in order for us to open
this database. Is it something they have to adjust on their end?

Any comments or suggestions would be greatly appreciated.

Thank you

 

[Brendan Reynolds]

a) Have you copied the MDB from the CD to a folder on your local hard disk
where you have read and write permissions, such as your 'My Documents'
folder, rather than trying to open it directly from the CD?

b) If you are using a version of Windows earlier than Windows XP, such as
Windows 2000 or Windows 98, have you cleared the Read Only attribute on the
file? (Right-click the file, choose properties, uncheck the Read Only check
box).

If you have done all of the above, and are still getting the error message,
then the problem may be at their end - they may need to send you a workgroup
(MDW) file as well as the MDB.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Guest]

We have copied the file from the CD to the local Drive. We are running
Windows XP, and made sure that the read only check has been cleared.

Is it the system.mdw file they would send us?

Thank you for your response.

 

[Brendan Reynolds]

If they have secured the MDB, you need the MDW they used to secure it. Only
they can tell you what that was. It is good practice *not* to use the
default system.mdw, but to create one for the purpose, but many
less-experienced users do use the default system.mdw. Don't replace your own
system.mdw with theirs, instead, place the MDW they send you in a different
folder, and create a shortcut to open the MDB using the MDW they send you.
The shortcut command line will look something like this ...

"C:\Your Folder\Your MDB.MDB" /wrkgrp "C:\You Folder\Your MDW.mdw"

The quotes above, around the path/name of the MDB and MDW, are required if
there are any spaces in the path/name, other wise you can leave out the
quotes. If you do use the quotes, make sure that the /wrkgrp option is
*outside* the quotes, as in the example above.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Joan Wild]

"C:\Your Folder\Your MDB.MDB" /wrkgrp "C:\You Folder\Your MDW.mdw"

Slight correction - that target needs the full path to msaccess.exe at the
beginning, or the switch will be ignored.

 

[Brendan Reynolds]

Thanks, Joan. I knew I'd always used the path to the Access EXE, but I
mistakenly assumed that was because I usually had more than one version of
Access on my PC.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[jaykayan]

Brendan, you're the man! It worked for me, only challenge i experience is, it's requesting for a password which i happen not to know