Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

How to break link between system.mdw and Access 97

Posted on 2002-05-14
6
Medium Priority
?
491 Views
Last Modified: 2008-07-03
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
Comment
Question by:smoyano
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
6 Comments
 
LVL 6

Expert Comment

by:blakeh1
ID: 7009354
Are they using a shortcut that uses the /wrkgrp switch to specify the workgroup file
0
 

Author Comment

by:smoyano
ID: 7009367
Thanks blakeh1. They are not using a shortcut but are instead double clicking on the .mdb file in Explorer.
0
 

Author Comment

by:smoyano
ID: 7009463
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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Accepted Solution

by:
wilmet earned 600 total points
ID: 7009744
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
 

Author Comment

by:smoyano
ID: 7009748
Thank you wilmet. I will be there tomorrow and will get back to you.
0
 

Author Comment

by:smoyano
ID: 7014081
It worked.
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question