Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 510
  • 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
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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