|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Remove Security from AccessDear All
I used User-level Security wizard. It maked a caos and I decided to remove it. I deleted system.mdw files on my pc and finally uninstalled MS-Access. Reinstalled MS-Access and I still can't get access to design mode on forms. When I look at Users and Groups Permissions, it shows that Current Owner for all DB elements is <Unknown>. This project is critical for me, please help! Ladi Ladi wrote:
> Dear All If you secured it properly then you MUST use the secured workgroup file to > > I used User-level Security wizard. > It maked a caos and I decided to remove it. I deleted system.mdw > files on my pc and finally uninstalled MS-Access. > Reinstalled MS-Access and I still can't get access to design mode on > forms. When I look at Users and Groups Permissions, it shows that > Current Owner for all DB elements is <Unknown>. > This project is critical for me, please help! > > Ladi get in and then after you are in the file there are things you can do to remove security. If you also deleted the secured workgroup file or if you mistakenly applied security using the system MDW file that you deleted then you are screwed unless... a) that file is still in your recycle bin or recoverable from backup or b) you have a backup of the file from before you applied security (you should have). On the chance that you applied incomplete security you might find that while you cannot open the file, you might be able to import all of its objects into a new blank file and recover that way. -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Rick,
I did a similar mistake as original post. I added a user when I was in the MDW file. I have deleted the mdw but no matter what access database I get into I am promted for the user name and password. If I try to creat a new db I still am proimted for a user name and psw. I have 50 dbs on my computer. Now I am prompted for the id and psw for all of them. What can i do? Show quoteHide quote "Rick Brandt" wrote: > Ladi wrote: > > Dear All > > > > I used User-level Security wizard. > > It maked a caos and I decided to remove it. I deleted system.mdw > > files on my pc and finally uninstalled MS-Access. > > Reinstalled MS-Access and I still can't get access to design mode on > > forms. When I look at Users and Groups Permissions, it shows that > > Current Owner for all DB elements is <Unknown>. > > This project is critical for me, please help! > > > > Ladi > > If you secured it properly then you MUST use the secured workgroup file to > get in and then after you are in the file there are things you can do to > remove security. If you also deleted the secured workgroup file or if you > mistakenly applied security using the system MDW file that you deleted then > you are screwed unless... > > a) that file is still in your recycle bin or recoverable from backup > > or > > b) you have a backup of the file from before you applied security (you > should have). > > On the chance that you applied incomplete security you might find that while > you cannot open the file, you might be able to import all of its objects > into a new blank file and recover that way. > > -- > Rick Brandt, Microsoft Access MVP > Email (as appropriate) to... > RBrandt at Hunter dot com > > > You need to rejoin the standard system.mdw workgroup file that ships with
Access, using the workgroup administrator (don't need a mdb file open to get to this) in Tools, Security menu. If joining system.mdw doesn't do it for you, then locate all mdw files on your system and rename them. Then open Access and it'll create a new pristine system.mdw. -- Show quoteHide quoteJoan Wild Microsoft Access MVP Eric Blitzer wrote: > Rick, > > I did a similar mistake as original post. I added a user when I was > in the MDW file. I have deleted the mdw but no matter what access > database I get into I am promted for the user name and password. If > I try to creat a new db I still am proimted for a user name and psw. > I have 50 dbs on my computer. Now I am prompted for the id and psw > for all of them. What can i do? > > "Rick Brandt" wrote: > >> Ladi wrote: >>> Dear All >>> >>> I used User-level Security wizard. >>> It maked a caos and I decided to remove it. I deleted system.mdw >>> files on my pc and finally uninstalled MS-Access. >>> Reinstalled MS-Access and I still can't get access to design mode on >>> forms. When I look at Users and Groups Permissions, it shows that >>> Current Owner for all DB elements is <Unknown>. >>> This project is critical for me, please help! >>> >>> Ladi >> >> If you secured it properly then you MUST use the secured workgroup >> file to get in and then after you are in the file there are things >> you can do to remove security. If you also deleted the secured >> workgroup file or if you mistakenly applied security using the >> system MDW file that you deleted then you are screwed unless... >> >> a) that file is still in your recycle bin or recoverable from backup >> >> or >> >> b) you have a backup of the file from before you applied security >> (you should have). >> >> On the chance that you applied incomplete security you might find >> that while you cannot open the file, you might be able to import all >> of its objects into a new blank file and recover that way. >> >> -- >> Rick Brandt, Microsoft Access MVP >> Email (as appropriate) to... >> RBrandt at Hunter dot com 
Other interesting topics
Workgroup locks database even when all users are shut down.
How so we join an existing workgroup in Access 2007 beta ? Access Database Security It won't let me in. Secure application design Access-Security-Can't get to design view, help won't help Blocking Access tables from other Office apps Access instalation Joining a workgroup. When i copied my database to a CD is says the database is 'read on |
|||||||||||||||||||||||
