• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 513
  • 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work 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

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

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