Access 2007 and SQL Server 2008 Express Logon

Discussion in 'Access Security' started by ggregg, May 27, 2010.

  1. ggregg

    ggregg Guest

    I had an Access 2000 program with workgrops that I recently converted to
    2007. The user requires Security, so I have been learning SQL Server 2008
    Express. I am using SQL Server Authentication to logon to SSE. I have
    linked the Access program to the tables on SSE. When I open the Access
    program, it doesn’t open a logon as I had expected. How can I use the SSE
    security in my Access program? Do I have to use an Access Project? I read
    that Projects don’t integrate with other programs, such as Microsoft Office
    Outlook 2007. I need to be able to do this. The user also requires
    Replication and Run Times.
    Thanks
     
    ggregg, May 27, 2010
    #1
    1. Advertisements

  2. ggregg

    ggregg Guest

    I was also wondering; can an Access Front End Database obtain the Login name
    and Role from SQL Server?
     
    ggregg, May 27, 2010
    #2
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.