T
thread
hi all,
does anyone know how can i delete a security made by the security
wizard
(in access 2000)
does anyone know how can i delete a security made by the security
wizard
(in access 2000)
Install the app
How to install the app on iOS
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
W
Wolfgang Kais
Hello "thread".
Log an as the owner of the database.
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.
thread said: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.
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.
R
Rick Brandt
thread said: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
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).
T
thread
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)?
what is the best way to copy all the data from one access file to
another?(including tables,queries,macros and vba code)?
R
Rick Brandt
thread said: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:
If you do the procedure in my previous post then you will get all of your
data.
T
thread
from some reason the password is not requested anymore but the file is
secure what should i do?
Wolfgang Kais כתב:
secure what should i do?
Wolfgang Kais כתב:
W
Wolfgang Kais
Hello "thread".
from some reason the password is not requested anymore but the
file is secure what should i do?
Either, connect to the correct workgroup file using wrkgadm.exe
or start Access using the /wrkgrp switch with the correct path to the
mdw file.
Or did someone delete the password of the admin user? If so,
give him a password.
Regards,
Wolfgang
Log an as the owner of the database.
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.
from some reason the password is not requested anymore but the
file is secure what should i do?
Either, connect to the correct workgroup file using wrkgadm.exe
or start Access using the /wrkgrp switch with the correct path to the
mdw file.
Or did someone delete the password of the admin user? If so,
give him a password.
Regards,
Wolfgang
T
thread
the issue is that i tried to take out the security and i zip the
security file,this is why the security is not working anymore
no on my computer and the rest of the computers that using this file is
not as well but there is not connection to what it did
can you direct me how can i get rid of this security step by step if
i'm accually the administrator of the file and the security password is
not requested any more even that the file is technicly secured
Wolfgang Kais כתב:
security file,this is why the security is not working anymore
no on my computer and the rest of the computers that using this file is
not as well but there is not connection to what it did
can you direct me how can i get rid of this security step by step if
i'm accually the administrator of the file and the security password is
not requested any more even that the file is technicly secured
Wolfgang Kais כתב:
W
Wolfgang Kais
Hello "thread".
I think that you have already got the answer.
You need the security file. Unzip it or recreate it using the same
workgroup name and code that you documented when creating the
"security file" (workgroup information file, mdw).
If this is not possible, ask your IT to restore a backup that was
hopefully made.
If this is not possible: I can't tell what to do.
the issue is that i tried to take out the security and i zip the
security file,this is why the security is not working anymore
no on my computer and the rest of the computers that using this file is
not as well but there is not connection to what it did
can you direct me how can i get rid of this security step by step if
i'm accually the administrator of the file and the security password is
not requested any more even that the file is technicly secured
I think that you have already got the answer.
You need the security file. Unzip it or recreate it using the same
workgroup name and code that you documented when creating the
"security file" (workgroup information file, mdw).
If this is not possible, ask your IT to restore a backup that was
hopefully made.
If this is not possible: I can't tell what to do.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.