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

x
?
Solved

Access MDW - no permission to enable/convert database

Posted on 2004-10-07
8
Medium Priority
?
1,088 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
Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

 

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 800 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

660 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