security problem. PLEASE HELP

ga11ardo

Registered User.
Local time
Today, 08:01
Joined
Sep 26, 2007
Messages
13
I tried to set user security levels without really knowing what i was doing. I know bad idea; but the worse idea was i did not currently have a backup copy of the database. I used the security wizard and it created a [filename].mdw If i open that file, none of my tables, forms, ect. are there. If i try to open the original database it says "You do not have the necessary permission to use [filename]..." I have tried everything i could think of but like i said i don't know much about access security. I have looked online and forums and couldn't figure it out still. The file is to big to upload or I would so everyone could look at it. Please help with this. If you are willing, I could email you the database and the .mdw so you could take a look at it. I have been working on this database for a long time and don't want to lose it. It is for work, and if i lose the database... bad things will happen. please help.
 
I have figured out that my admin account does not have permission to open/run the database. I cannot assign this permission because it says i do not own the database; however, neither do any of my other users. None of them can open/run it either.
 
Do you still have a non secured copy of the database?

If so, get rid of the secured one. Do a study on Access security and try again.

Theres a post here somewhere that has a link to a good security manual. Ill try to find it.
 
Last edited:
Found it.

For an excellent overview of Access security, go to:
http://www.geocities.com/jacksonmacd
download the first file – Security Paper by Jack Macdonald. It’s a little long but it tells you everything you need to know.
 
no i do not have a non-secured copy. i only have the original, which i cannot access. and the .mdw which does not have any of my forms ect in it.
 
I have no idea if this will work or not as I'm not up on security myself but it should only take a few minutes to find out.

Create a new blank database.

See if it will allow you to import the tables, forms queries etc. from your secured database.
 
i tried importing but i still get the "you do not have the necessary permission to open..." error message. I have read the security guide and still am unable to figure it out. If anyone knows a lot about access security and is able to fix my database i will paypal you $10 because I am desperate to get this fixed. once again i can email you the full database if you let me know.
 
not that i know anything about access security, but you cant simply open the mdw file and add the user admin to the Admins group? I assume that it has been removed.

just my uneducated view
 
Access Security can be tricky. Let me see if I can get you going in a proper direction.
Here are a few questions:
1) Did you create a user level ID and Password for the database in the workgroup file?
If you did try entering that ID and Password regardless of what the user ID in Access automatically populates to
(Usually your windows logon ID)
If you didn't create any user id or password then don't enter a password and don't change the ID from the windows logon id Just click OK at the logon dialog prompt.


If that didn't work then:

2) Is the mdw you refer to your workgroup file for that database? because there is a default workgroup for MS Access. Something like this:
C:\Documents and Settings\YourWindowsLogonID\Application Data\Microsoft\Access\System.mdw

You may have to join the NEW workgroup you created in order to open the database. OR You may have joined the new workgroup when you created it and just don't know it, but your database actually is in the default workgroup. You'd have to rejoin the default workgroup if that is true.

For help with workgroup related problems, In the MS Access HELP look up : Log on to a workgroup information file

Let us know stepwise, you might want to track your trouble shooting, what happens, so that we can offer more ideas if you still need help.

Cheers!
Goh
 

Users who are viewing this thread

Back
Top Bottom