PC Review


Reply
Thread Tools Rate Thread

Database Permissions Nightmare

 
 
Gary
Guest
Posts: n/a
 
      8th Jul 2003
Hi. I have a database that I created. I have set up a
Workgroup file for security which works great when I call
it as part of the shortcut. In Workgroup Administrator
(after wards), I set the Workgroup to the Sysem.mdw file.
Now if I use the shortcut, I get my security prompt and
all is well. But if I call the database directly I get
the following:

You do not have the necessary permissions to use the
<name> object. Have your system administrator or the
person who created this object establish the appropriate
permissions for you. (Error 3033)

Shouldn't the database just use the default System file?
Is there something else I need to change?

Thanks,

Any help is appreciated.

Gary
 
Reply With Quote
 
 
 
 
Joan Wild
Guest
Posts: n/a
 
      8th Jul 2003
Sounds right to me. The point of securing it is that you want people to
access it only if they have been authenticated via your secure workgroup
file. If the database opens using the default system.mdw, then anyone could
open it.

Do you want people to be able to open the database without logging in (it is
possible)?

--
Joan Wild
Microsoft Access MVP

"Gary" <(E-Mail Removed)> wrote in message
news:004d01c3455c$f94dd040$(E-Mail Removed)...
> Hi. I have a database that I created. I have set up a
> Workgroup file for security which works great when I call
> it as part of the shortcut. In Workgroup Administrator
> (after wards), I set the Workgroup to the Sysem.mdw file.
> Now if I use the shortcut, I get my security prompt and
> all is well. But if I call the database directly I get
> the following:
>
> You do not have the necessary permissions to use the
> <name> object. Have your system administrator or the
> person who created this object establish the appropriate
> permissions for you. (Error 3033)
>
> Shouldn't the database just use the default System file?
> Is there something else I need to change?
>
> Thanks,
>
> Any help is appreciated.
>
> Gary



 
Reply With Quote
 
 
 
 
Joan Wild
Guest
Posts: n/a
 
      8th Jul 2003
Permissions are stored in the mdb file. The workgroup holds users, groups,
memberships. You can't just join another workgroup and open the database.
If you want to unsecure the database, there are steps in the FAQ to do this
http://support.microsoft.com/?kbid=207793

Basically you log in to the database, give permissions for all objects back
to the Users Group.

Open Access using the default system.mdw workgroup, start a new database,
and import all the objects from your 'secure' database. It will no longer
be secure.

--
Joan Wild
Microsoft Access MVP

"Gary" <(E-Mail Removed)> wrote in message
news:8ac901c3456d$f4243030$(E-Mail Removed)...
> I would like to be able to get back in without the
> Security.
>



 
Reply With Quote
 
New Member
Join Date: Mar 2009
Posts: 2
 
      9th Mar 2009
Please some help needed.

i was using access 2000 from start to create a database but somewhere in the middle i have installed access 2003 and continue working with my database. in a order to prevent appearing that security warning window on the start i run security wizard . and didn't manage to find anything about but i accidenttly created a workgroup . on the security wizard i was only clicking next ,next and i didn't set any password. but it seems that the wizard has made security.mdw file and a shortcut for my database from where i was able to start my database, and a logon screen was appearing with only my username "alek" and no password and with only clicking OK my database was opening with full permissions. but somehow i have deleted the security file and now this message appears <b>You do not have the necessary permissions to use the <name> object. Have your system administrator or the person who created this object establish the appropriate permissions for you. (Error 3033)</b>
i went to as many forums about this problem and i have tried many things like creating new mdw file with full permissions for admins and users , i have created user "alek" in this new file and give him admin rights , and then joined this file to my database through shortcut "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Documents and Settings\alek\Desktop\potsetnik1.0.mdb" /WRKGRP "C:\Documents and Settings\alek\Desktop\security1.mdw" /user "alek" . but nothing helped.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Vista Permissions Nightmare 2 - Cannot Copy to my own Folder devistated Windows Vista General Discussion 4 24th Oct 2008 10:27 PM
Re: ultimate: permissions permissions permissions... Colon Terminus Windows Vista General Discussion 0 14th Apr 2008 07:14 PM
Database DEsign Nightmare =?Utf-8?B?U3R1IEpvaG5zdG9u?= Microsoft Access Database Table Design 4 27th May 2005 03:01 PM
problems relating to Client Permissions - NT Security Descriptor vs. MAPI Permissions in Exchange 2003 Bill Nguyen Microsoft Outlook 0 3rd Aug 2004 10:02 PM
Permissions nightmare !!bogus Microsoft Windows 2000 5 15th Dec 2003 06:22 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:09 AM.