Creating 10 Different Users For A Database Application nouveauricheinvestments[ at ]gmail.com 11/4/2008 5:43:57 PM Hello all, I have spent the last two weeks (baptism by fire) designing an access database and I am now at the point where I want to define about 10 different users that can access it. I don't have any idea how to do this. I will have certain options disabled for most users as well as certain forms. I imagine I will have to do something with a module. I am really familiar with Excel coding and I have done a little bit of access coding. If someone could point me in the right direction, I should be able to make it happen. Thanks in advance.

Re: Creating 10 Different Users For A Database Application "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_gmail.com> 11/5/2008 1:11:48 AM Sounds like you need to introduce Access User-Level Security, something not to be undertaken lightly! Assuming you're using Access 2003 or earlier, take a look at http://support.microsoft.com/support/access/content/secfaq.asp (don't worry that it only lists versions 2.0 through 2000 in the title: it applies equally to 2002 and 2003). Unfortunately, if you're using Access 2007, you're out of luck: ULS has been removed from the product. Read it carefully several times, work with a copy of your database (just in case!) and don't leave out any of the steps. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) <nouveauricheinvestments[ at ]gmail.com> wrote in message news:ae7a7857-198f-4dcb-b11d-62c7d12cba87[ at ]r15g2000prh.googlegroups.com... [Quoted Text] > Hello all, > > I have spent the last two weeks (baptism by fire) designing an access > database and I am now at the point where I want to define about 10 > different users that can access it. I don't have any idea how to do > this. I will have certain options disabled for most users as well as > certain forms. I imagine I will have to do something with a module. > I am really familiar with Excel coding and I have done a little bit of > access coding. If someone could point me in the right direction, I > should be able to make it happen. > > Thanks in advance.

Re: Creating 10 Different Users For A Database Application "Joan Wild" <jwild[ at ]nospamtyenet.com> 11/11/2008 2:55:43 PM "Douglas J. Steele" <NOSPAM_djsteele[ at ]NOSPAM_gmail.com> wrote in message news:eCIu7NuPJHA.4372[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] > Sounds like you need to introduce Access User-Level Security, something > not to be undertaken lightly! > > Assuming you're using Access 2003 or earlier, take a look at > http://support.microsoft.com/support/access/content/secfaq.asp (don't > worry that it only lists versions 2.0 through 2000 in the title: it > applies equally to 2002 and 2003). Unfortunately, if you're using Access > 2007, you're out of luck: ULS has been removed from the product. Actually it is still there, as long as you use the mdb format, and not the accdb format. -- Joan Wild Microsoft Access MVP