rusco
asked on
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
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
ASKER
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.
Yup, I'm 'joined to the correct workgroup file' but am still getting the 'error message' when I try to open the program.
(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
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
ASKER
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Pete!
Ok...thanks for trying though :-)
rusco
Ok...thanks for trying though :-)
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