|
security
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
New Post - Owner deleted - No backups, nothing!Joan Wild gave up! Can anyone else help me?
Database (MS Access 2003) That someone deleted the designer of the DB. No one knows anything, but I do not know enough about it to hack into it. I have asked for Network Admin rights to the folder it is in and all files in that folder. Still waiting for those rights. I have rights to the DB, but can not even look at the macros. I can look at the queries and tables and forms, but can not modify anything on them. I must somehow unsecured the DB and get ownership of it again. I am not sure if anyone other then the designer had admin rights, but somehow they managed to delete him and I am not even sure what his user name was. Why Me? Joan Wild is an MVP, whom I doubt would have just "given up"!
I have not seen your original thread, so I can't comment on what you were told, but it seems to me that since you can see the queries, tables and forms, but not change anything, then what you have is an MDE or ADE. If that's the case, then you're just out of luck, and there's nothing that anyone can do about it. End of story. Can you verify the file extension? MDB, MDE, ADP, ADE? Regards, Graham R Seach Microsoft Access MVP Sydney, Australia --------------------------- Show quoteHide quote "Why ME?" <Wh***@discussions.microsoft.com> wrote in message news:1A164A5B-B520-471A-BC13-64CB39A0F9FB@microsoft.com... > Joan Wild gave up! Can anyone else help me? > > Database (MS Access 2003) That someone deleted the designer of the DB. > > No one knows anything, but I do not know enough about it to hack into it. > I > have asked for Network Admin rights to the folder it is in and all files > in > that folder. > > Still waiting for those rights. > > I have rights to the DB, but can not even look at the macros. I can look > at > the queries and tables and forms, but can not modify anything on them. > > I must somehow unsecured the DB and get ownership of it again. I am not > sure if anyone other then the designer had admin rights, but somehow they > managed to delete him and I am not even sure what his user name was. > > Why Me? > > Graham: Thank you for responding! here is a copy of the old post:
how do I find who is an admin? Can I make myself an admin? Show quoteHide quote "Joan Wild" wrote: I have read many of Joan's posts looking for an answer to this mess. I > Well some user has to be a member of the Admins Group - log in as that user. > > -- > Joan Wild > Microsoft Access MVP > > Why ME? wrote: > > They deleted the person that created the database. I think that he > > signed on with his name as a user name. Not sure what that user name > > was, but when they deleted him all rights to look at macros, forms, > > queries has gone away. I am now charged with recovering the database > > and modifing it. > > > > "Scott McDaniel" wrote: > > > >> On Fri, 21 Jul 2006 11:34:01 -0700, Why ME? <Why > >> M**@discussions.microsoft.com> wrote: > >> > >>> Owner deleted - No backups, nothing! Need to modify and deveop > >>> this database > >> > >> Do you mean the username marked as "Owner" for your db has been > >> removed from the workgroup file? > >> > >>> > >>> MS Access 2003 > >>> > >>> How do I get thru the security? or delete the security totally? > >> > >> Scott McDaniel > >> scott@takemeout_infotrakker.com > >> www.infotrakker.com > > > "hear" in her writing condescending tone and not enough patience for a "MVP" I have 13 years with MS Access and I really need help in this matter. I have avoided Access Security because of great "Network" security where I have been. If this is a dead-end, please reconmend software that can be bought. I can not beleive that Microsoft wrote such a poor Security feature that someone can blow away the creator of the DB and yet not be able to become "Owner" of the DB. Show quoteHide quote "Graham R Seach" wrote: > Joan Wild is an MVP, whom I doubt would have just "given up"! > > I have not seen your original thread, so I can't comment on what you were > told, but it seems to me that since you can see the queries, tables and > forms, but not change anything, then what you have is an MDE or ADE. If > that's the case, then you're just out of luck, and there's nothing that > anyone can do about it. End of story. > > Can you verify the file extension? MDB, MDE, ADP, ADE? > > Regards, > Graham R Seach > Microsoft Access MVP > Sydney, Australia > --------------------------- > > "Why ME?" <Wh***@discussions.microsoft.com> wrote in message > news:1A164A5B-B520-471A-BC13-64CB39A0F9FB@microsoft.com... > > Joan Wild gave up! Can anyone else help me? > > > > Database (MS Access 2003) That someone deleted the designer of the DB. > > > > No one knows anything, but I do not know enough about it to hack into it. > > I > > have asked for Network Admin rights to the folder it is in and all files > > in > > that folder. > > > > Still waiting for those rights. > > > > I have rights to the DB, but can not even look at the macros. I can look > > at > > the queries and tables and forms, but can not modify anything on them. > > > > I must somehow unsecured the DB and get ownership of it again. I am not > > sure if anyone other then the designer had admin rights, but somehow they > > managed to delete him and I am not even sure what his user name was. > > > > Why Me? > > > > > > > ....and that's giving up?? Joan is starting to guide you through the
troubleshooting process. Take her advice - see if someone else in the organisation is able to log on. If so, problem partially solved - come back and ask what to do next. If not, then come back and ask for more help - don't just pass her advice off as having "given up". Also, I notice you still haven't answered my question! Can you verify the file extension? MDB, MDE, ADP, ADE? Regards, Graham R Seach Microsoft Access MVP Sydney, Australia --------------------------- Show quoteHide quote "Why ME?" <Wh***@discussions.microsoft.com> wrote in message news:41B581A2-035C-4BFA-9FB3-191DAC368EA5@microsoft.com... > Graham: Thank you for responding! here is a copy of the old post: > > how do I find who is an admin? Can I make myself an admin? > > "Joan Wild" wrote: > >> Well some user has to be a member of the Admins Group - log in as that >> user. >> >> -- >> Joan Wild >> Microsoft Access MVP >> >> Why ME? wrote: >> > They deleted the person that created the database. I think that he >> > signed on with his name as a user name. Not sure what that user name >> > was, but when they deleted him all rights to look at macros, forms, >> > queries has gone away. I am now charged with recovering the database >> > and modifing it. >> > >> > "Scott McDaniel" wrote: >> > >> >> On Fri, 21 Jul 2006 11:34:01 -0700, Why ME? <Why >> >> M**@discussions.microsoft.com> wrote: >> >> >> >>> Owner deleted - No backups, nothing! Need to modify and deveop >> >>> this database >> >> >> >> Do you mean the username marked as "Owner" for your db has been >> >> removed from the workgroup file? >> >> >> >>> >> >>> MS Access 2003 >> >>> >> >>> How do I get thru the security? or delete the security totally? >> >> >> >> Scott McDaniel >> >> scott@takemeout_infotrakker.com >> >> www.infotrakker.com >> >> >> > I have read many of Joan's posts looking for an answer to this mess. I > "hear" in her writing condescending tone and not enough patience for a > "MVP" > > I have 13 years with MS Access and I really need help in this matter. I > have > avoided Access Security because of great "Network" security where I have > been. > > If this is a dead-end, please reconmend software that can be bought. > > I can not beleive that Microsoft wrote such a poor Security feature that > someone can blow away the creator of the DB and yet not be able to become > "Owner" of the DB. > > "Graham R Seach" wrote: > >> Joan Wild is an MVP, whom I doubt would have just "given up"! >> >> I have not seen your original thread, so I can't comment on what you were >> told, but it seems to me that since you can see the queries, tables and >> forms, but not change anything, then what you have is an MDE or ADE. If >> that's the case, then you're just out of luck, and there's nothing that >> anyone can do about it. End of story. >> >> Can you verify the file extension? MDB, MDE, ADP, ADE? >> >> Regards, >> Graham R Seach >> Microsoft Access MVP >> Sydney, Australia >> --------------------------- >> >> "Why ME?" <Wh***@discussions.microsoft.com> wrote in message >> news:1A164A5B-B520-471A-BC13-64CB39A0F9FB@microsoft.com... >> > Joan Wild gave up! Can anyone else help me? >> > >> > Database (MS Access 2003) That someone deleted the designer of the DB. >> > >> > No one knows anything, but I do not know enough about it to hack into >> > it. >> > I >> > have asked for Network Admin rights to the folder it is in and all >> > files >> > in >> > that folder. >> > >> > Still waiting for those rights. >> > >> > I have rights to the DB, but can not even look at the macros. I can >> > look >> > at >> > the queries and tables and forms, but can not modify anything on them. >> > >> > I must somehow unsecured the DB and get ownership of it again. I am >> > not >> > sure if anyone other then the designer had admin rights, but somehow >> > they >> > managed to delete him and I am not even sure what his user name was. >> > >> > Why Me? >> > >> > >> >> >> Graham: It is a mdb file and yes I have the correct workgroup and yes I have
had a person login in who set me up and no they do not have anymore premissions than I do. Show quoteHide quote "Graham R Seach" wrote: > ....and that's giving up?? Joan is starting to guide you through the > troubleshooting process. Take her advice - see if someone else in the > organisation is able to log on. If so, problem partially solved - come back > and ask what to do next. If not, then come back and ask for more help - > don't just pass her advice off as having "given up". > > Also, I notice you still haven't answered my question! Can you verify the > file extension? MDB, MDE, ADP, ADE? > > Regards, > Graham R Seach > Microsoft Access MVP > Sydney, Australia > --------------------------- > > "Why ME?" <Wh***@discussions.microsoft.com> wrote in message > news:41B581A2-035C-4BFA-9FB3-191DAC368EA5@microsoft.com... > > Graham: Thank you for responding! here is a copy of the old post: > > > > how do I find who is an admin? Can I make myself an admin? > > > > "Joan Wild" wrote: > > > >> Well some user has to be a member of the Admins Group - log in as that > >> user. > >> > >> -- > >> Joan Wild > >> Microsoft Access MVP > >> > >> Why ME? wrote: > >> > They deleted the person that created the database. I think that he > >> > signed on with his name as a user name. Not sure what that user name > >> > was, but when they deleted him all rights to look at macros, forms, > >> > queries has gone away. I am now charged with recovering the database > >> > and modifing it. > >> > > >> > "Scott McDaniel" wrote: > >> > > >> >> On Fri, 21 Jul 2006 11:34:01 -0700, Why ME? <Why > >> >> M**@discussions.microsoft.com> wrote: > >> >> > >> >>> Owner deleted - No backups, nothing! Need to modify and deveop > >> >>> this database > >> >> > >> >> Do you mean the username marked as "Owner" for your db has been > >> >> removed from the workgroup file? > >> >> > >> >>> > >> >>> MS Access 2003 > >> >>> > >> >>> How do I get thru the security? or delete the security totally? > >> >> > >> >> Scott McDaniel > >> >> scott@takemeout_infotrakker.com > >> >> www.infotrakker.com > >> > >> > >> > > I have read many of Joan's posts looking for an answer to this mess. I > > "hear" in her writing condescending tone and not enough patience for a > > "MVP" > > > > I have 13 years with MS Access and I really need help in this matter. I > > have > > avoided Access Security because of great "Network" security where I have > > been. > > > > If this is a dead-end, please reconmend software that can be bought. > > > > I can not beleive that Microsoft wrote such a poor Security feature that > > someone can blow away the creator of the DB and yet not be able to become > > "Owner" of the DB. > > > > "Graham R Seach" wrote: > > > >> Joan Wild is an MVP, whom I doubt would have just "given up"! > >> > >> I have not seen your original thread, so I can't comment on what you were > >> told, but it seems to me that since you can see the queries, tables and > >> forms, but not change anything, then what you have is an MDE or ADE. If > >> that's the case, then you're just out of luck, and there's nothing that > >> anyone can do about it. End of story. > >> > >> Can you verify the file extension? MDB, MDE, ADP, ADE? > >> > >> Regards, > >> Graham R Seach > >> Microsoft Access MVP > >> Sydney, Australia > >> --------------------------- > >> > >> "Why ME?" <Wh***@discussions.microsoft.com> wrote in message > >> news:1A164A5B-B520-471A-BC13-64CB39A0F9FB@microsoft.com... > >> > Joan Wild gave up! Can anyone else help me? > >> > > >> > Database (MS Access 2003) That someone deleted the designer of the DB. > >> > > >> > No one knows anything, but I do not know enough about it to hack into > >> > it. > >> > I > >> > have asked for Network Admin rights to the folder it is in and all > >> > files > >> > in > >> > that folder. > >> > > >> > Still waiting for those rights. > >> > > >> > I have rights to the DB, but can not even look at the macros. I can > >> > look > >> > at > >> > the queries and tables and forms, but can not modify anything on them. > >> > > >> > I must somehow unsecured the DB and get ownership of it again. I am > >> > not > >> > sure if anyone other then the designer had admin rights, but somehow > >> > they > >> > managed to delete him and I am not even sure what his user name was. > >> > > >> > Why Me? > >> > > >> > > >> > >> > >> > > > Then the only thing I can think of is to purchase a security cracker, in
order to discover the Admin password. Try Googling for "access password recovery". Regards, Graham R Seach Microsoft Access MVP Sydney, Australia --------------------------- Show quoteHide quote "Why ME?" <Wh***@discussions.microsoft.com> wrote in message news:CE5446EC-727A-44D3-AD2A-244B45924DE0@microsoft.com... > Graham: It is a mdb file and yes I have the correct workgroup and yes I > have > had a person login in who set me up and no they do not have anymore > premissions than I do. > > "Graham R Seach" wrote: > >> ....and that's giving up?? Joan is starting to guide you through the >> troubleshooting process. Take her advice - see if someone else in the >> organisation is able to log on. If so, problem partially solved - come >> back >> and ask what to do next. If not, then come back and ask for more help - >> don't just pass her advice off as having "given up". >> >> Also, I notice you still haven't answered my question! Can you verify the >> file extension? MDB, MDE, ADP, ADE? >> >> Regards, >> Graham R Seach >> Microsoft Access MVP >> Sydney, Australia >> --------------------------- >> >> "Why ME?" <Wh***@discussions.microsoft.com> wrote in message >> news:41B581A2-035C-4BFA-9FB3-191DAC368EA5@microsoft.com... >> > Graham: Thank you for responding! here is a copy of the old post: >> > >> > how do I find who is an admin? Can I make myself an admin? >> > >> > "Joan Wild" wrote: >> > >> >> Well some user has to be a member of the Admins Group - log in as that >> >> user. >> >> >> >> -- >> >> Joan Wild >> >> Microsoft Access MVP >> >> >> >> Why ME? wrote: >> >> > They deleted the person that created the database. I think that he >> >> > signed on with his name as a user name. Not sure what that user >> >> > name >> >> > was, but when they deleted him all rights to look at macros, forms, >> >> > queries has gone away. I am now charged with recovering the database >> >> > and modifing it. >> >> > >> >> > "Scott McDaniel" wrote: >> >> > >> >> >> On Fri, 21 Jul 2006 11:34:01 -0700, Why ME? <Why >> >> >> M**@discussions.microsoft.com> wrote: >> >> >> >> >> >>> Owner deleted - No backups, nothing! Need to modify and deveop >> >> >>> this database >> >> >> >> >> >> Do you mean the username marked as "Owner" for your db has been >> >> >> removed from the workgroup file? >> >> >> >> >> >>> >> >> >>> MS Access 2003 >> >> >>> >> >> >>> How do I get thru the security? or delete the security totally? >> >> >> >> >> >> Scott McDaniel >> >> >> scott@takemeout_infotrakker.com >> >> >> www.infotrakker.com >> >> >> >> >> >> >> > I have read many of Joan's posts looking for an answer to this mess. I >> > "hear" in her writing condescending tone and not enough patience for a >> > "MVP" >> > >> > I have 13 years with MS Access and I really need help in this matter. I >> > have >> > avoided Access Security because of great "Network" security where I >> > have >> > been. >> > >> > If this is a dead-end, please reconmend software that can be bought. >> > >> > I can not beleive that Microsoft wrote such a poor Security feature >> > that >> > someone can blow away the creator of the DB and yet not be able to >> > become >> > "Owner" of the DB. >> > >> > "Graham R Seach" wrote: >> > >> >> Joan Wild is an MVP, whom I doubt would have just "given up"! >> >> >> >> I have not seen your original thread, so I can't comment on what you >> >> were >> >> told, but it seems to me that since you can see the queries, tables >> >> and >> >> forms, but not change anything, then what you have is an MDE or ADE. >> >> If >> >> that's the case, then you're just out of luck, and there's nothing >> >> that >> >> anyone can do about it. End of story. >> >> >> >> Can you verify the file extension? MDB, MDE, ADP, ADE? >> >> >> >> Regards, >> >> Graham R Seach >> >> Microsoft Access MVP >> >> Sydney, Australia >> >> --------------------------- >> >> >> >> "Why ME?" <Wh***@discussions.microsoft.com> wrote in message >> >> news:1A164A5B-B520-471A-BC13-64CB39A0F9FB@microsoft.com... >> >> > Joan Wild gave up! Can anyone else help me? >> >> > >> >> > Database (MS Access 2003) That someone deleted the designer of the >> >> > DB. >> >> > >> >> > No one knows anything, but I do not know enough about it to hack >> >> > into >> >> > it. >> >> > I >> >> > have asked for Network Admin rights to the folder it is in and all >> >> > files >> >> > in >> >> > that folder. >> >> > >> >> > Still waiting for those rights. >> >> > >> >> > I have rights to the DB, but can not even look at the macros. I can >> >> > look >> >> > at >> >> > the queries and tables and forms, but can not modify anything on >> >> > them. >> >> > >> >> > I must somehow unsecured the DB and get ownership of it again. I am >> >> > not >> >> > sure if anyone other then the designer had admin rights, but somehow >> >> > they >> >> > managed to delete him and I am not even sure what his user name was. >> >> > >> >> > Why Me? >> >> > >> >> > >> >> >> >> >> >> >> >> >> Graham: Thanks for your help on this! Sorry I rocked the boat in "MVP"
land.... Show quoteHide quote "Graham R Seach" wrote: > Then the only thing I can think of is to purchase a security cracker, in > order to discover the Admin password. Try Googling for "access password > recovery". > > Regards, > Graham R Seach > Microsoft Access MVP > Sydney, Australia > --------------------------- > > "Why ME?" <Wh***@discussions.microsoft.com> wrote in message > news:CE5446EC-727A-44D3-AD2A-244B45924DE0@microsoft.com... > > Graham: It is a mdb file and yes I have the correct workgroup and yes I > > have > > had a person login in who set me up and no they do not have anymore > > premissions than I do. > > > > "Graham R Seach" wrote: > > > >> ....and that's giving up?? Joan is starting to guide you through the > >> troubleshooting process. Take her advice - see if someone else in the > >> organisation is able to log on. If so, problem partially solved - come > >> back > >> and ask what to do next. If not, then come back and ask for more help - > >> don't just pass her advice off as having "given up". > >> > >> Also, I notice you still haven't answered my question! Can you verify the > >> file extension? MDB, MDE, ADP, ADE? > >> > >> Regards, > >> Graham R Seach > >> Microsoft Access MVP > >> Sydney, Australia > >> --------------------------- > >> > >> "Why ME?" <Wh***@discussions.microsoft.com> wrote in message > >> news:41B581A2-035C-4BFA-9FB3-191DAC368EA5@microsoft.com... > >> > Graham: Thank you for responding! here is a copy of the old post: > >> > > >> > how do I find who is an admin? Can I make myself an admin? > >> > > >> > "Joan Wild" wrote: > >> > > >> >> Well some user has to be a member of the Admins Group - log in as that > >> >> user. > >> >> > >> >> -- > >> >> Joan Wild > >> >> Microsoft Access MVP > >> >> > >> >> Why ME? wrote: > >> >> > They deleted the person that created the database. I think that he > >> >> > signed on with his name as a user name. Not sure what that user > >> >> > name > >> >> > was, but when they deleted him all rights to look at macros, forms, > >> >> > queries has gone away. I am now charged with recovering the database > >> >> > and modifing it. > >> >> > > >> >> > "Scott McDaniel" wrote: > >> >> > > >> >> >> On Fri, 21 Jul 2006 11:34:01 -0700, Why ME? <Why > >> >> >> M**@discussions.microsoft.com> wrote: > >> >> >> > >> >> >>> Owner deleted - No backups, nothing! Need to modify and deveop > >> >> >>> this database > >> >> >> > >> >> >> Do you mean the username marked as "Owner" for your db has been > >> >> >> removed from the workgroup file? > >> >> >> > >> >> >>> > >> >> >>> MS Access 2003 > >> >> >>> > >> >> >>> How do I get thru the security? or delete the security totally? > >> >> >> > >> >> >> Scott McDaniel > >> >> >> scott@takemeout_infotrakker.com > >> >> >> www.infotrakker.com > >> >> > >> >> > >> >> > >> > I have read many of Joan's posts looking for an answer to this mess. I > >> > "hear" in her writing condescending tone and not enough patience for a > >> > "MVP" > >> > > >> > I have 13 years with MS Access and I really need help in this matter. I > >> > have > >> > avoided Access Security because of great "Network" security where I > >> > have > >> > been. > >> > > >> > If this is a dead-end, please reconmend software that can be bought. > >> > > >> > I can not beleive that Microsoft wrote such a poor Security feature > >> > that > >> > someone can blow away the creator of the DB and yet not be able to > >> > become > >> > "Owner" of the DB. > >> > > >> > "Graham R Seach" wrote: > >> > > >> >> Joan Wild is an MVP, whom I doubt would have just "given up"! > >> >> > >> >> I have not seen your original thread, so I can't comment on what you > >> >> were > >> >> told, but it seems to me that since you can see the queries, tables > >> >> and > >> >> forms, but not change anything, then what you have is an MDE or ADE. > >> >> If > >> >> that's the case, then you're just out of luck, and there's nothing > >> >> that > >> >> anyone can do about it. End of story. > >> >> > >> >> Can you verify the file extension? MDB, MDE, ADP, ADE? > >> >> > >> >> Regards, > >> >> Graham R Seach > >> >> Microsoft Access MVP > >> >> Sydney, Australia > >> >> --------------------------- > >> >> > >> >> "Why ME?" <Wh***@discussions.microsoft.com> wrote in message > >> >> news:1A164A5B-B520-471A-BC13-64CB39A0F9FB@microsoft.com... > >> >> > Joan Wild gave up! Can anyone else help me? > >> >> > > >> >> > Database (MS Access 2003) That someone deleted the designer of the > >> >> > DB. > >> >> > > >> >> > No one knows anything, but I do not know enough about it to hack > >> >> > into > >> >> > it. > >> >> > I > >> >> > have asked for Network Admin rights to the folder it is in and all > >> >> > files > >> >> > in > >> >> > that folder. > >> >> > > >> >> > Still waiting for those rights. > >> >> > > >> >> > I have rights to the DB, but can not even look at the macros. I can > >> >> > look > >> >> > at > >> >> > the queries and tables and forms, but can not modify anything on > >> >> > them. > >> >> > > >> >> > I must somehow unsecured the DB and get ownership of it again. I am > >> >> > not > >> >> > sure if anyone other then the designer had admin rights, but somehow > >> >> > they > >> >> > managed to delete him and I am not even sure what his user name was. > >> >> > > >> >> > Why Me? > >> >> > > >> >> > > >> >> > >> >> > >> >> > >> > >> > >> > > > No prob; we're all good swimmers. :-)
Regards, Graham R Seach Microsoft Access MVP Sydney, Australia --------------------------- Show quoteHide quote "Why ME?" <Wh***@discussions.microsoft.com> wrote in message news:B6878ECA-69AC-4705-BE25-110B93B72A45@microsoft.com... > Graham: Thanks for your help on this! Sorry I rocked the boat in "MVP" > land.... > > "Graham R Seach" wrote: > >> Then the only thing I can think of is to purchase a security cracker, in >> order to discover the Admin password. Try Googling for "access password >> recovery". >> >> Regards, >> Graham R Seach >> Microsoft Access MVP >> Sydney, Australia >> --------------------------- >> >> "Why ME?" <Wh***@discussions.microsoft.com> wrote in message >> news:CE5446EC-727A-44D3-AD2A-244B45924DE0@microsoft.com... >> > Graham: It is a mdb file and yes I have the correct workgroup and yes >> > I >> > have >> > had a person login in who set me up and no they do not have anymore >> > premissions than I do. >> > >> > "Graham R Seach" wrote: >> > >> >> ....and that's giving up?? Joan is starting to guide you through the >> >> troubleshooting process. Take her advice - see if someone else in the >> >> organisation is able to log on. If so, problem partially solved - come >> >> back >> >> and ask what to do next. If not, then come back and ask for more >> >> help - >> >> don't just pass her advice off as having "given up". >> >> >> >> Also, I notice you still haven't answered my question! Can you verify >> >> the >> >> file extension? MDB, MDE, ADP, ADE? >> >> >> >> Regards, >> >> Graham R Seach >> >> Microsoft Access MVP >> >> Sydney, Australia >> >> --------------------------- >> >> >> >> "Why ME?" <Wh***@discussions.microsoft.com> wrote in message >> >> news:41B581A2-035C-4BFA-9FB3-191DAC368EA5@microsoft.com... >> >> > Graham: Thank you for responding! here is a copy of the old post: >> >> > >> >> > how do I find who is an admin? Can I make myself an admin? >> >> > >> >> > "Joan Wild" wrote: >> >> > >> >> >> Well some user has to be a member of the Admins Group - log in as >> >> >> that >> >> >> user. >> >> >> >> >> >> -- >> >> >> Joan Wild >> >> >> Microsoft Access MVP >> >> >> >> >> >> Why ME? wrote: >> >> >> > They deleted the person that created the database. I think that >> >> >> > he >> >> >> > signed on with his name as a user name. Not sure what that user >> >> >> > name >> >> >> > was, but when they deleted him all rights to look at macros, >> >> >> > forms, >> >> >> > queries has gone away. I am now charged with recovering the >> >> >> > database >> >> >> > and modifing it. >> >> >> > >> >> >> > "Scott McDaniel" wrote: >> >> >> > >> >> >> >> On Fri, 21 Jul 2006 11:34:01 -0700, Why ME? <Why >> >> >> >> M**@discussions.microsoft.com> wrote: >> >> >> >> >> >> >> >>> Owner deleted - No backups, nothing! Need to modify and deveop >> >> >> >>> this database >> >> >> >> >> >> >> >> Do you mean the username marked as "Owner" for your db has been >> >> >> >> removed from the workgroup file? >> >> >> >> >> >> >> >>> >> >> >> >>> MS Access 2003 >> >> >> >>> >> >> >> >>> How do I get thru the security? or delete the security totally? >> >> >> >> >> >> >> >> Scott McDaniel >> >> >> >> scott@takemeout_infotrakker.com >> >> >> >> www.infotrakker.com >> >> >> >> >> >> >> >> >> >> >> > I have read many of Joan's posts looking for an answer to this mess. >> >> > I >> >> > "hear" in her writing condescending tone and not enough patience for >> >> > a >> >> > "MVP" >> >> > >> >> > I have 13 years with MS Access and I really need help in this >> >> > matter. I >> >> > have >> >> > avoided Access Security because of great "Network" security where I >> >> > have >> >> > been. >> >> > >> >> > If this is a dead-end, please reconmend software that can be bought. >> >> > >> >> > I can not beleive that Microsoft wrote such a poor Security feature >> >> > that >> >> > someone can blow away the creator of the DB and yet not be able to >> >> > become >> >> > "Owner" of the DB. >> >> > >> >> > "Graham R Seach" wrote: >> >> > >> >> >> Joan Wild is an MVP, whom I doubt would have just "given up"! >> >> >> >> >> >> I have not seen your original thread, so I can't comment on what >> >> >> you >> >> >> were >> >> >> told, but it seems to me that since you can see the queries, tables >> >> >> and >> >> >> forms, but not change anything, then what you have is an MDE or >> >> >> ADE. >> >> >> If >> >> >> that's the case, then you're just out of luck, and there's nothing >> >> >> that >> >> >> anyone can do about it. End of story. >> >> >> >> >> >> Can you verify the file extension? MDB, MDE, ADP, ADE? >> >> >> >> >> >> Regards, >> >> >> Graham R Seach >> >> >> Microsoft Access MVP >> >> >> Sydney, Australia >> >> >> --------------------------- >> >> >> >> >> >> "Why ME?" <Wh***@discussions.microsoft.com> wrote in message >> >> >> news:1A164A5B-B520-471A-BC13-64CB39A0F9FB@microsoft.com... >> >> >> > Joan Wild gave up! Can anyone else help me? >> >> >> > >> >> >> > Database (MS Access 2003) That someone deleted the designer of >> >> >> > the >> >> >> > DB. >> >> >> > >> >> >> > No one knows anything, but I do not know enough about it to hack >> >> >> > into >> >> >> > it. >> >> >> > I >> >> >> > have asked for Network Admin rights to the folder it is in and >> >> >> > all >> >> >> > files >> >> >> > in >> >> >> > that folder. >> >> >> > >> >> >> > Still waiting for those rights. >> >> >> > >> >> >> > I have rights to the DB, but can not even look at the macros. I >> >> >> > can >> >> >> > look >> >> >> > at >> >> >> > the queries and tables and forms, but can not modify anything on >> >> >> > them. >> >> >> > >> >> >> > I must somehow unsecured the DB and get ownership of it again. I >> >> >> > am >> >> >> > not >> >> >> > sure if anyone other then the designer had admin rights, but >> >> >> > somehow >> >> >> > they >> >> >> > managed to delete him and I am not even sure what his user name >> >> >> > was. >> >> >> > >> >> >> > Why Me? >> >> >> > >> >> >> > >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> >> "Why ME?" <Wh***@discussions.microsoft.com> wrote in message This isn't an MS helpdesk and no-one owes you a reply. Had you considered news:1A164A5B-B520-471A-BC13-64CB39A0F9FB@microsoft.com... > Joan Wild gave up! that Joan might have left her PC for a few days? I'm sure she has a life away from here, as do we all. Do you have the correct workgroup file? Keith. Is the problem that you can't change anything or that you literally can't see
code, table choices, etc.? When the database opens up, hold down shift while clicking on Open. If your problem is that the window doesn't show any tables options, forms, macro's choices, etc. that should take care of the problem. Hope that helps and if it doesn't well maybe someone else will stumble across it in a time of need. -- Later, Darrin Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-security/200607/1 Sorry dear, I did not give up. I went on vacation for a week (indeed am
still on vacation). Given that you can get into the tables/queries/macros, I suspect that you have a mde file. Just because it has a mdb extension, doesn't mean it is a mdb. That could have been changed. Also since someone was able to get in and 'set up your account', that username is a member of the Admins group. -- Show quoteHide quoteJoan Wild Microsoft Access MVP Why ME? wrote: > Joan Wild gave up! Can anyone else help me? > > Database (MS Access 2003) That someone deleted the designer of the DB. > > No one knows anything, but I do not know enough about it to hack into > it. I have asked for Network Admin rights to the folder it is in and > all files in that folder. > > Still waiting for those rights. > > I have rights to the DB, but can not even look at the macros. I can > look at the queries and tables and forms, but can not modify anything > on them. > > I must somehow unsecured the DB and get ownership of it again. I am > not sure if anyone other then the designer had admin rights, but > somehow they managed to delete him and I am not even sure what his > user name was. > > Why Me? 
Other interesting topics
Security in fields
Re: User and Workgroup was screwed Preventing design changes with share-based security Workgroup file in Network drive and Local computer Creating a workgroup Detecting user with blank password? Exclusive Access Message......... Two DataBases, One Secure and One Not Hiding database window In Security, Workgroup Administrator Add Check Box to always point |
|||||||||||||||||||||||
