Solved

Access MDW - no permission to enable/convert database

Posted on 2004-10-07
8
1,069 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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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…
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
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 …

746 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

11 Experts available now in Live!

Get 1:1 Help Now