link an MDW file to a database (1 Viewer)
- Thread starter Traden
- Start date
Autoeng
Why me?
- Local time
- Today, 04:34
- Joined
- Aug 13, 2002
- Messages
- 1,302
An mdw file (also called a workgrooup) is only required if you have placed security on the db. During the process of applying security you should have named the .mdw file something other than the default system.mdw. If you didn't this will give you headaches as every Access user has system.mdw and will be able to circumnavigate your security.
As for how the security works you must use a shortcut which joins the appropriate workgroup and loads the db. When you applied the security a shortcut should have been created for you. Now as you have the db and the security workgroup both on a network source your shortcut would appear as such.
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"x:\networklocation\yourdb.mdb"
/WRKGRP "x:\nwtworklocation\yourworkgroup.mdw"
There have been a tremendous amount of post concerning security and Microsoft has a very good faq on the subject here
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp
I urge you to read this document several times to truly understand security.
As for how the security works you must use a shortcut which joins the appropriate workgroup and loads the db. When you applied the security a shortcut should have been created for you. Now as you have the db and the security workgroup both on a network source your shortcut would appear as such.
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"x:\networklocation\yourdb.mdb"
/WRKGRP "x:\nwtworklocation\yourworkgroup.mdw"
There have been a tremendous amount of post concerning security and Microsoft has a very good faq on the subject here
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp
I urge you to read this document several times to truly understand security.
thanks
thanks for your help, i did as you told me, mdw file i created before. I typed text and saved it as a .bat file, but ot doesn`t work. It just opens access when i do open with the selection field of DB as it oopens when you open access direct, not the db i want and no workgroupfile..when i change the lines, first giviing location of db, then workgrouppatch, and then access it says:
the process can not access the file cause in use by another process
to work
/WRKGRP is not recognized as an interal or external command..
and opens access at least...
please help
thanks for your help, i did as you told me, mdw file i created before. I typed text and saved it as a .bat file, but ot doesn`t work. It just opens access when i do open with the selection field of DB as it oopens when you open access direct, not the db i want and no workgroupfile..when i change the lines, first giviing location of db, then workgrouppatch, and then access it says:
the process can not access the file cause in use by another process
to work
/WRKGRP is not recognized as an interal or external command..
and opens access at least...
please help
Last edited:
