Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004

    Unanswered: Microsoft Access


    I a trying to set a user logon in Microsoft Access, so that when a user enters there logon say cs, it will store this in a field which can then be used in a table.

    Does anyone know of a way to do this?



  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Jet (the database engine used by MS-Access) doesn't really support the idea of logins. There is a similar concept of the database "owner", but Jet only distinguishes between connections that use the owner password and ones that don't.

    You could create an application login, and store that information in a table, but I'm not sure what good that would do you.

    You might want to consider using MSDE. It is essentially a scaled down version of MS-SQL that is provided with MS-Access Professional, and is available for distribution as part of the MS-Access Developer Edition. MSDE supports the login concept nicely.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts