"You don't have the necessary permissions" message

[Mike Johnson]

I created a .mdb and copied it to a network drive. It was
accessible for a few days. Now, whenever we try to open
the file, we get "You don't have the nessary permissions
to use the 'database.mdb' object. Have your system
administrator or the person who created this object
establish the appropriate permissions for you."

Nobody can access the database. Not even me, and I
created it. How can I fix this???

Thanks.

 

[Uncle Jean]

"Mike Johnson" told the uncle and all the others:

» I created a .mdb and copied it to a network drive. It was
» accessible for a few days. Now, whenever we try to open
» the file, we get "You don't have the nessary permissions
» to use the 'database.mdb' object. Have your system
» administrator or the person who created this object
» establish the appropriate permissions for you."
»
» Nobody can access the database. Not even me, and I
» created it. How can I fix this???
»
» Thanks.

======================

Mike,

Possible that it is now "Read Only" ???
UJ

 

[Mike]

-----Original Message-----
"Mike Johnson" told the uncle and all the others:

» I created a .mdb and copied it to a network drive. It was
» accessible for a few days. Now, whenever we try to open
» the file, we get "You don't have the nessary permissions
» to use the 'database.mdb' object. Have your system
» administrator or the person who created this object
» establish the appropriate permissions for you."
»
» Nobody can access the database. Not even me, and I
» created it. How can I fix this???
»
» Thanks.

======================

Mike,

Possible that it is now "Read Only" ???
UJ


.

The file is Rw when I go to a netware prompt and check
the "flag". The properties in Windows don't show it as
read only, either. I wish it was that easy.

 

[Uncle Jean]

"Mike" told the uncle and all the others:

» The file is Rw when I go to a netware prompt and check
» the "flag". The properties in Windows don't show it as
» read only, either. I wish it was that easy.

===========================

Maybe one of your programs is blocking access to it ? Sorry I
can't help you more.

UJ

 

[Mike]

It doesn't have a security tab.

-----Original Message-----
This sounds like a problem that I'm getting. If you are using WinXP/2000
does the file have a Security tab when you check its properties?
Brian



.

 

[Guest]

This sounds like a problem that I'm getting. If you are using WinXP/2000
does the file have a Security tab when you check its properties?
Brian

 

[Guest]

Is there any other file in the folder? Does it have the security tab?
Basically what seems to be happening to me is that you put the file in the
folder and then if a user other than an administrator logs into the computer
and uses the file the security settings disappear when another non-admin
user logs and tries to use the file. Does this sound familiar?
Brian

 

[Guest]

What works for the short term is forcing the file to inherit the permissions
of other files in the folder and then the security tab comes back and
usually adding permissions for the everyone group lets you back into the
file. Unfortunately I have yet found out how to make the permissions stick.
Brian

 

[Joan Wild]

I created a .mdb and copied it to a network drive. It was
accessible for a few days. Now, whenever we try to open
the file, we get "You don't have the nessary permissions
to use the 'database.mdb' object. Have your system
administrator or the person who created this object
establish the appropriate permissions for you."

That suggests that this mdb was secured using Access user level security,
and you are now opening it using the wrong workgroup file.

You should be able to create a desktop shortcut that starts Access, opens
the database using the correct mdw file. The target looks like:

"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"