Security

  • Thread starter Thread starter Maabhasan
  • Start date Start date
M

Maabhasan

Hello.

I need help in opening my access database. I keep getting
the same error messages

["You do not have the necessary permission s to use
the 'C:\Documents and Settings\hasana\Desktop\Electric and
Gas Supplier.mdb' object. Have your system administor or
the person who created the object establish the
appropriate permissions for you."]

and I can't get into it. I had all the Secrity features
set on it. What should I do now.
 
Maabhasan said:
["You do not have the necessary permission s to use
the 'C:\Documents and Settings\hasana\Desktop\Electric and
Gas Supplier.mdb' object. Have your system administor or
the person who created the object establish the
appropriate permissions for you."]

and I can't get into it. I had all the Secrity features
set on it. What should I do now.
Click to expand...

You are likely joined to the wrong workgroup. Try creating a desktop
shortcut with the following in the target:

"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"
 
Please could you be more specific or precise about
the "desktop shortcut with the following in the target:

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

I have never done this before...writing the path..

Thank you
A. Hasan


-----Original Message-----
Maabhasan said:
["You do not have the necessary permission s to usewith
Click to expand...
the following in the target:

"path to msaccess.exe" "path to mdb" /wrkgrp "path to secure mdw"
the 'C:\Documents and Settings\hasana\Desktop\Electric and
Gas Supplier.mdb' object. Have your system administrator or
the person who created the object establish the
appropriate permissions for you."]

and I can't get into it. I had all the Secrity features
set on it. What should I do now.
Click to expand...

You are likely joined to the wrong workgroup. Try creating a desktop
shortcut with the following in the target:

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

--
Joan Wild
Microsoft Access MVP


.
Click to expand...
 
Locate the msaccess.exe file on your computer. Depending on version you'll
find it in something like the C:\Program Files\Microsoft Office\Office
folder. Right click the file, choose Send To, and the Desktop as shortcut.

Go to the desktop and you'll see a shortcut. Right-click it and choose
rename and give it a more meaningful name. Right-click it and choose
properties; on the dialog that opens you'll see a textbox called 'Target'
with the path to msaccess.exe. Click at the end of that and add
"path to mdb" /wrkgrp "path to mdw"

substitute "path to mdb" with the path to your mdb file and "path to mdw"
with the path to the workgroup file that you used to secure the database
with.
 
Hi
Thank you very much.
I tried what you said "Click at the end of that and add"
the path, but it keeps giving me error messages and I have
to cancel it.

This is the path for MSAccess.exe

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"

This is th path for the database "path to mdb" file

"\\Nwkna01\Users\hasana\Working Data\Electric and Gas
Supplier.mdb"

And this for the /wrkgrp "path to mdw" file

"\\Nwkna01\Users\hasana\Working Data\Secured.mdw"

Could you please explain it once more how it should be
written.

Would appreciate your help.

Thank you
Abida Hasan
 
Hi
Thank you very much.
I tried what you said "Click at the end of that and add"
the path, but it keeps giving me error messages and I have
to cancel it.
Click to expand...

What is the error message?

This is how it should be (all on one line of course)

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"
"\\Nwkna01\Users\hasana\Working Data\Electric and Gas Supplier.mdb" /wrkgrp
"\\Nwkna01\Users\hasana\Working Data\Secured.mdw"

Each path is within double quotes(") and there is a space between each
section.
 
Thank you very much....
It worked.

Abida Hasan


-----Original Message-----


What is the error message?

This is how it should be (all on one line of course)

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"
"\\Nwkna01\Users\hasana\Working Data\Electric and Gas Supplier.mdb" /wrkgrp
"\\Nwkna01\Users\hasana\Working Data\Secured.mdw"

Each path is within double quotes(") and there is a space between each
section.


--
Joan Wild
Microsoft Access MVP



.
Click to expand...
 
Back
Top