Solved

Access MDW - no permission to enable/convert database

Posted on 2004-10-07
8
1,082 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
[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
  • 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
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
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…

630 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