Level security

  • Thread starter Thread starter Loi
  • Start date Start date
L

Loi

Hi,
To create a short cut, I just right click the Equipment
database (create a short cut) and put it to desk top. I
really don't know "The following should be in the
target:"path to msaccess.exe............"

Please show me how to do it.
Thank you
Loi

-----------------------------------
Create a desktop shortcut for the Equipment database. The
following should
be in the target:

"path to msaccess.exe" "path to equipment
database" /wrkgrp "path to secure
mdw"
 
Loi said:
Hi,
To create a short cut, I just right click the Equipment
database (create a short cut) and put it to desk top. I
really don't know "The following should be in the
target:"path to msaccess.exe............"

Please show me how to do it.
Click to expand...

From your other messages, I assume you are using Access 97.

Right-click the shortcut you created on the desktop, and choose properties.
It will open and you'll see the textbox beside 'target' and it will have the
path to your Equipment database in it.

Click at the very beginning of that path and type
"C:\Program Files\Microsoft Office\Office\Msaccess.exe"

(include the double quotes and put a space between it and the path to your
database). Note that if you are using a different version of Access, you
may need to adjust the path. You can use Start, Search and locate the
msaccess.exe file to get the correct path.

Next, go to the end of your target and type a space followed by
/wrkgrp "C:\path\secure.mdw"
(substitute the correct path to your secure workgroup file that you created,
for the C:\path...etc.)
 
Hi,

My name is Amy Vargo. Thank you for using the Microsoft Access Newsgroups.

First create a shortcut to the database. Then right-click on the shortcut
and choose properties. You will see a target line. This is where you need
to enter the path to msaccess.exe enclosed in quotes, and then a space,
then the path to the .mdb file enclosed in quotes. If this is a secured
database, you will need to enter the path to the workgroup file using the
/wrkgrp switch. For example:

"C:\Program Files\Microsoft Office\Office10\msaccess.exe"
"C:\MyDatabase\Northwind.mdb" /wrkgrp "C:\MyDatabase\Secured.mdw"

If you do not know where msaccess.exe is located, open a Search window and
search for it in your C: drive. Use your path.

I included some relevant links below.

305542 Understanding the Role of Workgroup Information Files in Access
Security
http://support.microsoft.com/?id=305542

232390 ACC: How to Share a Secured Database on a Network
http://support.microsoft.com/?id=232390

209207 ACC2000: How to Use Command-Line Switches in Microsoft Access
http://support.microsoft.com/?id=209207


I hope this helps! If you have additional questions on this topic, please
respond back to this posting.


Regards,

Amy Vargo
Microsoft Access Engineer


This posting is provided 'AS IS' with no warranties, and confers no rights.
You assume all risk for your use. © 2001 Microsoft Corporation. All rights
reserved.
 
Good morning!
I really appreciate for all your help.

I am ok with "target" now. However, I have another
question, please.

Because I made a big mess in my computer when I set up
security leve (97),I deleted the new workgroup which I
created and security database. I like to start from
beginning. However, any time I open Access 97, the logon
box is appeared. Please show me how to get of it.

________
When I created a new workgroup, I gave it a new name and
new location. Do you think Ok for me to join back to the
original one which is created when people install Access
97.?

Thank you
 
Loi said:
Good morning!
I really appreciate for all your help.

I am ok with "target" now. However, I have another
question, please.

Because I made a big mess in my computer when I set up
security leve (97),I deleted the new workgroup which I
created and security database.
Click to expand...

I take it that you deleted the mdw as well as the secure mdb, and you have a
backup of the original unsecured mdb?
I like to start from
beginning. However, any time I open Access 97, the logon
box is appeared. Please show me how to get of it.
Click to expand...

Use Start, Run, wrkgadm.exe. This will start the workgroup administrator
and show you that you are joined by default to your secure mdw that you
created. Click on Join, and rejoin the standard system.mdw that ships with
Access (it usually is located in the windows system folder, but you can
search for it first).

If you want to implement security, try the step-by-step at
www.jmwild.com/AccessSecurity.htm.
 
Back
Top