I am using Access 2007, but most people in our office use Office 2003. So I saved my dabase as 2003 version to share data with them.
** However, after struggling hours try to figure out how to set security in Access. I am surprised to find that on my computer, when I open the database in old version *.mdb format, the Adminster option sit on the ribbon as usual(the one that shows Users and Permissions), but if I open the database in *.accdb format, the Administer option just disappear . This driving me crazy, how can this be?
** I look up the book and guess maybe I need to restore the default workgroup, but in Access2007, how to do it?
** Also, even though I don't need password for every dabase file, now for whatever database I open, Access is forced me to log in password? !
** Seems the security set up now all messed up, is there a way I can undo all of them and start over?
Oh my goodness I am tearing my hair out for all this trouble. ( seems setting Access security is much more tricky than I thought). Can someone give me some clue? I'd really really appreciate it. Thanks !!!!!
Yu
** However, after struggling hours try to figure out how to set security in Access. I am surprised to find that on my computer, when I open the database in old version *.mdb format, the Adminster option sit on the ribbon as usual(the one that shows Users and Permissions), but if I open the database in *.accdb format, the Administer option just disappear . This driving me crazy, how can this be?
** I look up the book and guess maybe I need to restore the default workgroup, but in Access2007, how to do it?
** Also, even though I don't need password for every dabase file, now for whatever database I open, Access is forced me to log in password? !
** Seems the security set up now all messed up, is there a way I can undo all of them and start over?
Oh my goodness I am tearing my hair out for all this trouble. ( seems setting Access security is much more tricky than I thought). Can someone give me some clue? I'd really really appreciate it. Thanks !!!!!
Yu