Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

link table manager, plz help ...

Discussion in 'Information Technology' started by Andrew, Oct 28, 2005.

  1. Andrew

    Andrew
    Expand Collapse
    Guest

    Hi all,

    I have a problem with my sql server database logon.
    I linked my access mdb file to the sql server on the network (using the
    link-table manager), setting the Data Source ODBC > SystemDSN to my server.
    My code runs fine accessing the linked sql server.

    However I find that whenever I open my access file and run my code, ie. this
    line e.g. "set db=db.openRecordset(strsql)" for the FIRST TIME, it will
    PROMPT ME for my sql server username and password. Why is this so ? I always
    thought that when I set the DSN and linked the db tables to access using the
    link-table manager, I wouldn't have to logon each time to the sql server.
    This happens each time when I am accessing each of my tables for the FIRST
    TIME.

    Thanks.
    Andrew.
     
  2. Loading...


  3. Ofer

    Ofer
    Expand Collapse
    Guest

    To over come this problem, when you set the ODBC connection, change the
    connection to Authentication instead of login (user and password), that way
    the user name will be the user that login the computer
    --
    If I answered your question, please mark it as an answer. That way, it will
    stay saved for a longer time, so other can benifit from it.

    Good luck



    "Andrew" wrote:

    > Hi all,
    >
    > I have a problem with my sql server database logon.
    > I linked my access mdb file to the sql server on the network (using the
    > link-table manager), setting the Data Source ODBC > SystemDSN to my server.
    > My code runs fine accessing the linked sql server.
    >
    > However I find that whenever I open my access file and run my code, ie. this
    > line e.g. "set db=db.openRecordset(strsql)" for the FIRST TIME, it will
    > PROMPT ME for my sql server username and password. Why is this so ? I always
    > thought that when I set the DSN and linked the db tables to access using the
    > link-table manager, I wouldn't have to logon each time to the sql server.
    > This happens each time when I am accessing each of my tables for the FIRST
    > TIME.
    >
    > Thanks.
    > Andrew.
    >
     
  4. Andrew

    Andrew
    Expand Collapse
    Guest

    Hi,

    I solved the problem, seems that I did not tick the "save password" tickbox
    when I used the link table manager to link my db from the sql server.

    Thanks for your reply anyway.

    cheers,
    Andrew.

    "Ofer" wrote:

    > To over come this problem, when you set the ODBC connection, change the
    > connection to Authentication instead of login (user and password), that way
    > the user name will be the user that login the computer
    > --
    > If I answered your question, please mark it as an answer. That way, it will
    > stay saved for a longer time, so other can benifit from it.
    >
    > Good luck
    >
    >
    >
    > "Andrew" wrote:
    >
    > > Hi all,
    > >
    > > I have a problem with my sql server database logon.
    > > I linked my access mdb file to the sql server on the network (using the
    > > link-table manager), setting the Data Source ODBC > SystemDSN to my server.
    > > My code runs fine accessing the linked sql server.
    > >
    > > However I find that whenever I open my access file and run my code, ie. this
    > > line e.g. "set db=db.openRecordset(strsql)" for the FIRST TIME, it will
    > > PROMPT ME for my sql server username and password. Why is this so ? I always
    > > thought that when I set the DSN and linked the db tables to access using the
    > > link-table manager, I wouldn't have to logon each time to the sql server.
    > > This happens each time when I am accessing each of my tables for the FIRST
    > > TIME.
    > >
    > > Thanks.
    > > Andrew.
    > >
     

Share This Page