Lost permissions to Access db after installing Office Update SR-1

  • Thread starter Thread starter Wes
  • Start date Start date
W

Wes

Recently I have been working on a database within Access
2000 on a Windows XP Pro computer. I had set up security
using the security wizard, and choose the option for a
workgroup file (Secured.mdw) that sits alongside the mdb
file. From then on, I had opened the database, and was
prompted for the password for the username in the text box
above it. Because every time I started an Office
application, it prompted me to update Office, I stuck my
Office 2000 cd in and let it update. I then downloaded
and installed Office Update SR-1. After rebooting, I
tried to open the database mdb file, and was prompted with
the following message: "You do not have the necessary
permissions to use the 'C:\db\lagis.mdb' object. Have your
system administrator or the person who created the object
establish the appropriate permissions for you." Is there
any way to fix this... or just delete the security on the
mdb file, since a lot of information was added and not
backed up right before the update was installed, and I
would like the mdb file data back.
 
You just need to point Access at the security workgroup again.

Go to C:\Program Files\Microsoft Office\Office and look for MS Access
Workgroup Administrator.
Double-click on it.
Click Join.
Browse to your Secured.mdw.
Click OK until all the windows go away.

You should now be able to open your database.

HTH,
Marshall Smith
Project Developers, Inc.
 
Wes, it seems you do not use Access for anything else on your computer,
because if you do then it would ask you for the username and password for
*every* database you try to open.

A better solution is to leave your default workgroup set to the default file
(system.mdw) and set up a shortcut in the start menu or desktop to open your
secured database. The target for the shortcut should be:

<path to msaccess.exe> <path to your database> /wrkgrp:<path to your mdw>

For example:

"C:\Program Files\Microsoft Office\Office\msaccess.exe"
"C:\db\lagis.mdb" /wrkgrp:"C:\db\secured.mdw"

--
Good Luck!
Graham Mandeno [Access MVP]
Auckland, New Zealand

Return mail address is invalid in a vain attempt to reduce spam.
Feedback is welcome at: (e-mail address removed)
Please post new questions or followups to newsgroup.
 
As Graham said, it is better to create a new workgroup file for your secured
application.

Another reason why - extra to what he said - is that the default workgroup
file is created using default settings that are readily visible in other
places on your PC (completely seperate from MS Access). Anyone who has
physical access to your PC, could create a new, default workgroup file, &
break right on in to your ol' app!

HTH,
TC
 
Back
Top