Error-You do not have the necessary permission..

[adamnorsworthy]

Hello,

I get this error when opening my MS Access database - You do not have the necessary permissions to use the ...[flie name and path]... object. Have your system administrator or the person who created this object establish the necessary permissions for you.

The database works fine on another computer, but every time I transfer it to mine (I am on a network), I get the above error. I have recreated the User-level security workgroup file, no joy.

Can you help?

 

[The_Doc_Man]

So you rebuilt the workgroup file. Did you remember to join it after you created it? It isn't automatic, you know.

 

[adamnorsworthy]

Yes, I joined it - still no luck

 

[The_Doc_Man]

(Putting on my security hat...)

When you are on another computer, are you logged in as the same user as on the machine exhibiting the problem?

Are these machines all in the same domain? (For older networks, are they all in the same network-level workgroup, not to be confused with an Office workgroup?)

The rule for network shares is that they minimize with the permissions on the shared object vis-a-vis its non-shared status. That is to say, you cannot ever have more permissions on the object than its most restrictive permission set. I.e. if locally you have WRITE access but the share is READ-ONLY, you have READ-ONLY access through the share regardless of who you are.

It sounds to me like a WINDOWS permission problem, not an ACCESS permissions problem. Try to examine the properties of the objects including all folders in the path from your problem machine to the DB in question. That includes all folders above the DB. Right-click on the object to get its properties. A tab on the properties dialog box will give you the security properties, and that is where you can find the permission set.

 

[GeorgeP]

Greetings,

this is my first post on this forum so I dont know if i am allowed to start a new thread or no. My knowledge of access databases is *very* limited and I found this site via google searching for a solution to a problem that has been nagging me and a couple of other guys for a few days now.

The question that I think! it comes down to is: how can a User ID be recovered when the .mdw file was lost ?

(it wasnt written down unfortunately for us)
As i understood from reading is this forum ( its great btw ) and extensive googleing the .mdw file must be recreated and joined.
Please correct me where i am wrong or where i am missing something !

Im sorry if i posted in the wrong place,
Thank you

 

[adamnorsworthy]

Thanks Doc Man & GP.

I am running a peer-to-peer network using IPX, with 2 Win XP machines. There is only one logon used for both XP machines, no passwords needed. I have tried opening earlier versions (I am currently on 11). Version 7 opened, version 8 comes up with the same error. Version 7 is not replicated - so I set it up for replication and that opens fine. Still no luck with version 8 or up though.

 

[queuegz]

My impression is that there is a tool "easy lan folder share" which can solve the problems easily.

you may search it at google.

 

[gemma-the-husky]

Greetings,

this is my first post on this forum so I dont know if i am allowed to start a new thread or no. My knowledge of access databases is *very* limited and I found this site via google searching for a solution to a problem that has been nagging me and a couple of other guys for a few days now.

The question that I think! it comes down to is: how can a User ID be recovered when the .mdw file was lost ?

(it wasnt written down unfortunately for us)
As i understood from reading is this forum ( its great btw ) and extensive googleing the .mdw file must be recreated and joined.
Please correct me where i am wrong or where i am missing something !

Im sorry if i posted in the wrong place,
Thank you

welcome, georgeP

My understanding is that you cannot recreate the mdw file without the initiallisation strings, and you may lose your database as a result.

There may be some services that might be able to help

Its a hard lesson to learn, but it emphasises the importance of backing everything up


-------
please join us, then you will certainly be able to post new threads