Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2003
    Location
    London, Gtr London, England
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access link to SQL server - stored password? (Access2000, SQLServer 7, ODB

    Hi Everyone.

    ***************************
    To summarise (with recently acquired information)

    I've found out about the ODBC connect script, which confirms that the username and password are correct.
    So, the question seems to be why MS Access stops using the password and requires the user to type it in after, for instance, the ODBC link has been updated?

    ***************************
    (and now all the detail)

    I'm trying to update an existing multiuser MS Access 2000 database that links
    to a table on SQL Server 7 (Microsoft SQL Server ODBC Driver Version
    03.81.9030). There is just one copy of the Access database that everyone
    executes from a server.

    The existing version of the Access database works such that the users do not
    have to type in any kind of user name or password. However, the problem is
    that I find my new version is insisting on a password when the SQL Server
    table is first looked at. It is taking the user name, but not the password,
    from the DSN entry.

    I have had a look at simply adding the new fields to the live version of the
    SQL server table, but experiments on a test copy seem to indicate that you have
    to update the link to make the new fields be recognised. This would be fine,
    except that a copy of the working access database that was linked to the
    working database began to fail after I had only updated the link.

    I have compared the DSN entries for the live and test copies of the SQL server
    table, and the link information within live and test copies of Access. They
    seem to be exactly the same. I have also checked the security menu items and
    if there are any command strings attached to a shortcut.

    I would be grateful for any ideas that anyone might have.

    Thanks

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Access link to SQL server - stored password? (Access2000, SQLServer 7,

    When you link a table via ODBC there is a check box asking if you wish to save the password (or something like this), make sure you chek this box when you initially link the table.

  3. #3
    New Lounger
    Join Date
    May 2003
    Location
    London, Gtr London, England
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thank you Pat!!!!

    I had just been changing the link address rather than creating a whole new Link.

    I was aware of there being a check box *somewhere* but had not come across it.

    Anyway, thanks again for a *very* quick and accurate response <img src=/S/bow.gif border=0 alt=bow width=15 height=15>

Posting Permissions

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