MDW file


P

Paul

I loaded a "homemade" Access DB onto my computer. I had to
use the WRKGADM.EXE utility to join it's MDW file so I
could troubleshoot the problem the user was having with
the DB. I needed full access to it. Now, ALL of my other
Access DBs have this DB's same security. In other words,
all my other DBs that didn't have security, now have
security.

If I use the WRKGADM.EXE, again, and join the MDW file
located in the C:\Program Files\Common Files\System, the
security is back off of my DBs but also the DB I am
troubleshooting. Why is that ?

I would like to be able to have the security for the DB I
am troubleshooting but at the same time, I don't want this
security on my other DBs. Can this be done ?

Thanks,
Paul
 
Ad

Advertisements

R

Rick Brandt

Paul said:
I loaded a "homemade" Access DB onto my computer. I had to
use the WRKGADM.EXE utility to join it's MDW file so I
could troubleshoot the problem the user was having with
the DB. I needed full access to it. Now, ALL of my other
Access DBs have this DB's same security. In other words,
all my other DBs that didn't have security, now have
security.

If I use the WRKGADM.EXE, again, and join the MDW file
located in the C:\Program Files\Common Files\System, the
security is back off of my DBs but also the DB I am
troubleshooting. Why is that ?

I would like to be able to have the security for the DB I
am troubleshooting but at the same time, I don't want this
security on my other DBs. Can this be done ?
Access User-Level security is "per session" not "per file".

Keep the unsecured mdw as your default and then create a shortcut that opens the
secured one. That shortcut can include a parameter that specifies the use of a
non-default mdw file.

"Path to MSAccess.exe" "Path to MDB" /wrkgrp "Path to mdw"
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MDW file 4
MDW Files 4
MDW FILE 2
.mdw files 1
MDW file 2
.mdw file 1
Default MDW file 2
Joining MDW files 1

Top