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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1092
  • Last Modified:

Access MDW - no permission to enable/convert database

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
rusco
Asked:
rusco
  • 3
  • 3
1 Solution
 
peter57rCommented:
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
 
ruscoAuthor Commented:
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
 
peter57rCommented:
(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
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.

 
ruscoAuthor Commented:
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
 
peter57rCommented:
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
 
ruscoAuthor Commented:
Hi Pete!

Ok...thanks for trying though :-)

rusco
0

Featured Post

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.

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