Solved

Access MDW - no permission to enable/convert database

Posted on 2004-10-07
8
1,071 Views
Last Modified: 2008-02-07
Hi experts!

I'm new to access security and I just got assigned to take over a program that uses an mdw file. Unforunately, the program can only work on one pc (for some odd reason), which means a lot of users have to line up to use it. I was given the program and the mdw as well as a username/password that is suppose to have access to modify the program but it gives me an warning that I have no permission to enable/convert the database.  Is there a way to reset the mdw such that I can fix it again so that the other users can be able to use it in their respective pc's?

They are using Access 2000.

Thanks in advance!

rusco
0
Comment
Question by:rusco
  • 3
  • 3
8 Comments
 
LVL 77

Expert Comment

by:peter57r
ID: 12256555
Hello rusco,

You need to be absolutely sure that you are joined to the correct mdw file when you start the database.
This might be done through a desktop shortcut which you use to start the application. If not you must use the Workgroup Administrator to join the correct workgroup file.
So the first question back must be 'are you joined to the correct workgroup file?'

Pete
0
 

Author Comment

by:rusco
ID: 12256618
Hi Pete!

Yup, I'm 'joined to the correct workgroup file' but am still getting the 'error message' when I try to open the program.
0
 
LVL 77

Expert Comment

by:peter57r
ID: 12256674
(I shall call the security workgroup for the application app.mdw; the default workgroup when not joined to the security workgroup will be system.mdw)
And in answer to one of your initial questions, there is no way to 'reset' the mdw.

When you start Access on its own  (not the application)  joined to app.mdw, are you able to log in succesfully?
Can you create new databases?
Can you do both of these when you are joined to the system.mdw?

Pete
0
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 

Author Comment

by:rusco
ID: 12256837
Hi Pete!

Yup, I can create and log in successfully when I'm joined to app.mdw or system.mdw. It's only with the application that I'm using itself that it's causing me not to be able to open the application.

Thanks!
0
 
LVL 77

Accepted Solution

by:
peter57r earned 200 total points
ID: 12257062
Then we have to conclude that either the login you have been given is unsuitable for that application or that security has been set up incorrectly in the application. Clearly you have a .mdw file which recognises the username and password that you believe to be  correct.

The fact that the application only runs on one pc might (only might) mean that the developer has installed additional security measures which tie it to that machine.

Now we have a different problem.
It is against the rules of this forum to assist anyone with removing or breaking security on an application.  However genuine you may feel your case is, no-one here can know that you are entitled to be using that application.

If you cannot find an alternative login which gives you the required permissions then you will have to search the net for products that will  disclose security settings or service providers who might be willing to get you into that database.  

Sorry.

Pete
0
 

Author Comment

by:rusco
ID: 12257090
Hi Pete!

Ok...thanks for trying though :-)

rusco
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

816 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now