do not have necessary permission to use this file

[Guest]

Hello All,
I developed and secured a access 200 database on my laptop and have
transferred the file to my desktop pc running access 2003. When I attempt to
open this file on my desktop i get the response " You do not have the
necessary permission to use the <file name> object. Have your system
administrator .........establish the appropriate permissions for you. I don't
even get the logon window to enable me to logon as the administrator.
Does anyone know what the problem is and how i can gain the necessary
permissions to open the database on my desktop?
Many thanks
Allan

 

[Allen Browne]

Could be Windows permissions or Access permissions.

Windows permissions
=================
Right-click the mdb file in the Windows Explorer.
Is it read-only?
Is there a security warning that the file is blocked, with an Unblock
button?
What about the permissions on the folder where the mdb is?

Access permissions
===============
When you open the database, do you enter a username and password? If so, you
may need to bring the system.mdw file as well as the mdb file so you can log
in with the desired permissions.

You can build a shortcut to the mdb that instructs it to use the particular
mdw file as well. The target for the shortcut would be something like this:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"C:\MyFolder\MyFile.mdb" /wrkgrp "C:\MyFolder\system.mdw"

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

in message
news:[email protected]...

 

[Guest]

Allen,
Thanksfor the two suggestions.
Unfortunately they did not fix the problem. I still get the same response,
that being " " You do not have the necessary permission to use the <file
name> object. Have your system administrator .........establish the
appropriate permissions for you." Pressing the help button on the error
message has not given me any hints as to what the problem is. It does mention
(Error 3033)
There is no security warning about a the file being blocked.
Do you have any more suggestions how to fix this?
Many thanks
Allan

 

[Allen Browne]

Error 3033 is an Access error message, so we know we are dealing with Access
permissions.

Unless the database is corrupt, this implies that there is an mdw file and
you don't have permission to use something. Does it literally say "<file
name>"? If so, it could imply a corruption.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

in message

 

[Guest]

Hi Allen,
No, the message refers to the directory that the file is sitting in and
mentions the actual file name. ie 'c:\Documents and settings\vip\my
documents\cwv-manta.mdb'object. Have your system..............appropriate
permissins for you.
I do not have any trouble opening the file on my laptop. All security
settings are behaving as set. My own logon is the administrator and I have a
few that are full data users and a few that are read only users. I need to be
able to transfer this file to other laptops and desktops.
Again, your time and assistance is greatly appreciated.
Regards
Allan

 

[Allen Browne]

If you right-click the file in the Windows Explorer, which boxes are
checked, and what buttons do you see?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

in message

 

[Guest]

Hi Allen
both files , the application and the system.mdw file have in their
properties window
showing three boxes, read-only, hidden and archive. The archive box is the
only one selected with a "tick".

 

[Allen Browne]

And you are sure that the mdw file you are referring to is the same one you
use on the other computer? And that you are signing in with the same user
name and password?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

in message