copy and paste mdw file

[hamking]

I've set up a database at work and now need to set user security.
Currently the database is on the network and different users are using
there own computer's system.mdw file to access. I've copied and
pasted my secured mdw file to the same folder of each user's computer,
and using the workgroup administrator have joined them to my mdw file.
However, two problems have occured:

1. The permissions for each group is now checked, where as they were
not on mine original mdw file. I have to go in and uncheck all the
permissions that weren't meant to be granted for the group.
2. Each user would be able to join their original system.mdw file and
than have full access to the database again.

Can anyone please help on these two issues. Thank you.

Hamilton

 

[Joan Wild]

I've set up a database at work and now need to set user security.
Currently the database is on the network and different users are using
there own computer's system.mdw file to access. I've copied and
pasted my secured mdw file to the same folder of each user's computer,
and using the workgroup administrator have joined them to my mdw file.

You could have put the secured.mdw on the server. Leave the users joined to
their default system.mdw and give them a desktop shortcut that points to the
secured mdw when they open your secure database. That way, they'll use
their default system.mdw for all other databases. You'll find it easier to
maintain the workgroup file if there is just one copy of it on the server.
The shortcut target would look like:
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"

However, two problems have occured:

1. The permissions for each group is now checked, where as they were
not on mine original mdw file. I have to go in and uncheck all the
permissions that weren't meant to be granted for the group.

That doesn't make sense at all.

2. Each user would be able to join their original system.mdw file and
than have full access to the database again.

If that's the case, then you didn't secure it properly in the first place.
Be sure you follow every step outlined in the FAQ. They should not be able
to even open the secured mdb using system.mdw. The FAQ is available at

http://support.microsoft.com/?id=207793

 

[Eric Butts [MSFT]]

Hi Hamilton,

Save yourself the headache and do the following:

- copy your *.MDW file to the same location the shared *.MDB file is

- then on each users computer create the following short-cut

"<full path to msaccess.exe>" "<full path to shared *.MDB>" /wrkgrp "<full
path to shared *.MDW file>"

Now when the users want to launch your secured database they use the
shortcut.

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


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights

--------------------
| From: (e-mail address removed) (hamking)
| Newsgroups: microsoft.public.access.security
| Subject: copy and paste mdw file
| Date: 27 Apr 2004 23:57:42 -0700
| Organization: http://groups.google.com
| Lines: 16
| Message-ID: <[email protected]>
| NNTP-Posting-Host: 68.121.242.56
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1083135462 24102 127.0.0.1 (28 Apr 2004
06:57:42 GMT)
| X-Complaints-To: (e-mail address removed)
| NNTP-Posting-Date: Wed, 28 Apr 2004 06:57:42 +0000 (UTC)
| Path:
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.s
ul.t-online.de!t-online.de!news.glorb.com!postnews1.google.com!not-for-mail
| Xref: cpmsftngxa10.phx.gbl microsoft.public.access.security:10326
| X-Tomcat-NG: microsoft.public.access.security
|
| I've set up a database at work and now need to set user security.
| Currently the database is on the network and different users are using
| there own computer's system.mdw file to access. I've copied and
| pasted my secured mdw file to the same folder of each user's computer,
| and using the workgroup administrator have joined them to my mdw file.
| However, two problems have occured:
|
| 1. The permissions for each group is now checked, where as they were
| not on mine original mdw file. I have to go in and uncheck all the
| permissions that weren't meant to be granted for the group.
| 2. Each user would be able to join their original system.mdw file and
| than have full access to the database again.
|
| Can anyone please help on these two issues. Thank you.
|
| Hamilton
|