Post reply

Converting Access MDW file to SQL Login

  • September 19, 2003 at 11:41 am

    #82259

    Is there any way to convert MSAccess Security file (MDW) to SQL login with password.

    I have lots of users in MSAccess with password and I wanted to convert it into SQL login with password . I just wanted to get rid of creating login and password again in SQL database.

    Thanks

  • September 19, 2003 at 1:35 pm

    #475112

    Scrap the whole thing and use Windows network logins. Use SQL Server and Windows authentication (sometimes called mixed mode). In Enterprise Manager, right click the DB, go to Security. Spend the effort to put users and groups together for the Windows network, and then you won't have to mess with SQL logins anymore.

  • September 22, 2003 at 5:38 pm

    #475331

    Thanks for the reply. I have to create SQL login for some other reasons. I don't know if we can transfer access password to SQL login password

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply