remove security from file

hi all,

does anyone know how can i delete a security made by the security
wizard

(in access 2000)


*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

thread wrote:
> hi all,
>
> does anyone know how can i delete a security made by the security
> wizard
>
> (in access 2000)

Open Access using the secured workgroup file and log in as someone with full
permissions on the file. Once in the file grant Full permissions to the
group "Users" on all objects.

Now close Access and reopen without using the secured workgroup and create a
new blank file. From that file import all of the objects from the previously
secured file. The permissions granted to "Users" should now allow you to do
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/14035-remove-security-from-file.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14035
this.

The resulting file will be identical to one that never had security applied.

However; the wizard normally makes a backup of your file so you should be
able to just revert to that (unless data has been entered since it was
secured).

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

yes data have been entered,
what is the best way to copy all the data from one access file to
another?(including tables,queries,macros and vba code)?
Rick Brandt wrote:
> thread wrote:
> > hi all,
> >
> > does anyone know how can i delete a security made by the security
> > wizard
> >
> > (in access 2000)
>
> Open Access using the secured workgroup file and log in as someone with full
> permissions on the file. Once in the file grant Full permissions to the
> group "Users" on all objects.
>
> Now close Access and reopen without using the secured workgroup and create a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14035
> new blank file. From that file import all of the objects from the previously
> secured file. The permissions granted to "Users" should now allow you to do
> this.
>
> The resulting file will be identical to one that never had security applied.
>
> However; the wizard normally makes a backup of your file so you should be
> able to just revert to that (unless data has been entered since it was
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14035
> secured).
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com

Hello "thread".

"thread" wrote:
> does anyone know how can i delete a security made by the
> security wizard (in access 2000)

Log an as the owner of the database.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14035
Grant all permissions for all objects to the Users group
Create a blank database using the default system.mdw file
and import all objects from the other database.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14035

--
Regards,
Wolfgang

thread wrote:
> yes data have been entered,
> what is the best way to copy all the data from one access file to
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14035
> another?(including tables,queries,macros and vba code)?
> Rick Brandt wrote:

If you do the procedure in my previous post then you will get all of your
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=14035
data.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com