By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,390 Members | 1,566 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,390 IT Pros & Developers. It's quick & easy.

MDW

P: n/a
I just took over maintaining a timekeeping package that is written in MS
Access with front-end and backend databases. The package has security
setting using MDW file.
The vendor also removed access right to the objects (tables, forms, queries,
etc) that users cannot copy and paste the objects outside the package. When
I was trying to copy and paste any of these objects, an Access error message
showed "You don't have the necessary permission to use this object. . . "
According to vendor, I have to run "C:\Program Files\Microsoft
Office\Office\MSACCESS.EXE" /wrkgrp "c:\Path to mdw file\ActualMDWFile.mdw"
to reconnect a MDW file to a backed-up database in order to make it
accessible. To me, that is annoying.

Here are my questions:
1. I noticed each user has a mdw file with different contents. How can I
synchronize this file that each user has the same content? Is that
important for me to do so?

2. What would be the best way to backup and restore? Since they remove
certain right to access the objects, I was not able to do the simplest way
backup and restore: copy important data tables to another MDB file. Any
suggestion on this? It seems to me the only way to backup and restore is to
use the above "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
/wrkgrp "c:\Path to mdw file\ActualMDWFile.mdw" to reconnect a copied
database to a mdw. Is that true?

3. What access rights have been removed? Any utilities or programs can be
used to recover?

Any comments are appreciated
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"miloann2002" <sh***@charter.net> wrote in message
news:Kc******************@fe06.lga...
According to vendor, I have to run "C:\Program Files\Microsoft
Office\Office\MSACCESS.EXE" /wrkgrp "c:\Path to mdw
file\ActualMDWFile.mdw"
to reconnect a MDW file to a backed-up database in order to make it
accessible. To me, that is annoying.
Just to clarify this, you need a desktop shortcut with a command line in the
format:

"Full pathe to MSACCESS.exe" "Full path to your app.mdb" /wrkgrp "Full path
to your security file.mdw"

including the quotation marks.

Here are my questions:
1. I noticed each user has a mdw file with different contents. How can I
synchronize this file that each user has the same content? Is that
important for me to do so?
There is a default "system.mdw" which Access uses to open all databases
unless instructed otherwise, either by your shortcut (above) or by using the
Workgroup Admin tool. To open a particular "secured" db your users will all
need the mdw file that was created during the "securing" process. This is
typically achieved by putting the mdw on a network where all users can see
it.

2. What would be the best way to backup and restore? Since they remove
certain right to access the objects, I was not able to do the simplest way
backup and restore: copy important data tables to another MDB file. Any
suggestion on this? It seems to me the only way to backup and restore is
to
use the above "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
/wrkgrp "c:\Path to mdw file\ActualMDWFile.mdw" to reconnect a copied
database to a mdw. Is that true?
You will always need to connect to a secured db using the appropriate mdw,
that's how it works.
3. What access rights have been removed?
I doubt anyone here can answer that one, the original developer will have
that info.
Any utilities or programs can be used to recover?


There are utilities available (at a cost) that will defeat Access security,
a Google search will reveal all.

HTH - Keith.
www.keithwilby.com
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.