Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 518
  • Last Modified:

How to break link between system.mdw and Access 97

A user has created an mdb, assigned rights to objects, used the work group administrator to join a work group, then, as far as I can tell, went back to an unsecured backup and renamed it to the original mdb file name.

They are being prompted for the mdw when they try to open the renamed unsecured backup.

What can we do to get rid of the link to the mdw? I have not been there yet to see if there is an mdw on the hard drive. I am told the copy on the network was deleted.

Thanks in advance for your help and please let me know if you need more information.
0
smoyano
Asked:
smoyano
  • 4
1 Solution
 
blakeh1Commented:
Are they using a shortcut that uses the /wrkgrp switch to specify the workgroup file
0
 
smoyanoAuthor Commented:
Thanks blakeh1. They are not using a shortcut but are instead double clicking on the .mdb file in Explorer.
0
 
smoyanoAuthor Commented:
blakeh1: It turns out that she is prompted for the .mdw when she starts access not only when she double-clicks on the mdb file.

0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
wilmetCommented:
Suggest that they use the Workgroup Administrator to join with "system.mdw" which is the defauly security file for Access.  It's usually located in the D:\Program Files\Microsoft Office\Office folder.
0
 
smoyanoAuthor Commented:
Thank you wilmet. I will be there tomorrow and will get back to you.
0
 
smoyanoAuthor Commented:
It worked.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now