Re: Creating user-level security with MS Access file on a network
- From: "Joan Wild" <jwild@xxxxxxxxxxxxxxxx>
- Date: Wed, 26 Oct 2005 12:12:01 -0400
jss wrote:
> The following is what my shortcuts targets:
>
> "\\Anthro84\c$\Program Files\Microsoft Office
> 2003\OFFICE11\MSACCESS.EXE" "Z:\TONT PHOTOS Database.mdb" /WRKGRP
> "Z:\Security.mdw"
I would modify this target to
"C:\Program Files\Microsoft Office 2003\Office11\msaccess.exe" ....
Also, you are better off using UNC pathnames, rather than relying on users
having the same drive mappings. So \\servername\share\...
You could work on getting this working and then consider....
In addition, it is recommended that you split the database so that just the
backend (tables only) sits on the server. Give each user a copy of the
frontend on their workstation (it would contain links to the backend). Then
your target would change to
"path to msaccess.exe "c:\path to frontend" /wrkgrp
"\\servername\share\...security.mdw"
> In looking at the shortcut target above, however, I wonder if the
> problem isn't that I am trying to open the mdw shortcut in Acess 2003
> when I only have Access 2002 on the machines I am trying to open it
> on. Do you think it would help if I went in and modified the target
> on the computers with Access 2002 to reflect the 2002 status.
Actually the security.mdw file isn't the problem here. On the 2002
machines, you will have to modify the path to msaccess.exe to reflect its
location on that machine (do a search for it). I'll guarantee it won't be
beneath c:\Program Files\Microsoft office 2003
Also,
> and I know this is very remedial, how do I go about making a new
> shortcut to the mdw on the other computers.
I would search for msaccess.exe on the computer (start, search). Right
click on it and 'send to desktop as shortcut'. Then go to the desktop and
right-click on the shortcut and choose properties. You'll be on the target
line and it will have the path to msaccess.exe there. Edit that line as
follows:
Leave the path as is.
Put double quotes around the path
Move to the end of the line and type
<space> "<Path to mdb>" <space> /wrkgrp <space> "<path to mdw>"
--
Joan Wild
Microsoft Access MVP
.
- References:
- Prev by Date: Access Security
- Next by Date: Re: Creating user-level security with MS Access file on a network
- Previous by thread: Re: Creating user-level security with MS Access file on a network
- Next by thread: Re: Make a table contents unviewable
- Index(es):
Relevant Pages
|
Loading
