Welcome to SPN

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

Sign Up Now!

ODBC table - save password

Discussion in 'Information Technology' started by Adam, Jul 28, 2006.

  1. Adam

    Adam
    Expand Collapse
    Guest

    Hi All,

    I have a database which has a few tables linked to an SQL server.

    I have setup a system dsn called 'CSC Data Repository'.

    When the database is opened i have a form open which links to a query.
    So as it is looking at the odbc linked tables it prompts me for the
    password each time.

    Is there a way I can save the odbc password in the database so it
    doesn't prompt me?

    Many Thanks!

    Adam
     
  2. Loading...

    Similar Threads Forum Date
    As A Child, Public Marches Of Sikhism Made Me Uncomfortable. They Still Do . Why ? Whats The Logic Hard Talk Oct 16, 2016
    Arts/Society Backyard Vegetable Garden Language, Arts & Culture Dec 27, 2013
    Heritage Now a Vegetable Market, Ranjit Singh's Royal Haveli a Picture of Neglect History of Sikhism Nov 11, 2013
    Sikhism Helium: 1984 and the "Periodic Table of Hate" (Jaspreet Singh) Book Reviews & Editorials Oct 28, 2013
    Heritage How our entire history was dumped in a horse stable History of Sikhism Oct 28, 2013

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Create a passthrough Query (User_Tables)
    SQL: SELECT * FROM INFORMATION_SCHEMA.Tables

    in the connect property add: ODBC;DSN=MyDsn;UID=MyUID;PWD=MyPwd ' + other
    relevant settings

    Open the Query through a recordset before opening your form

    You also can store the pwd if you use DoCmd.TransferDataBase to link the
    tables or Change The Connect Property of the TableDef

    HTH

    Pieter


    "Adam" <adamevans81@gmail.com> wrote in message
    news:1153220373.167538.114550@s13g2000cwa.googlegroups.com...
    > Hi All,
    >
    > I have a database which has a few tables linked to an SQL server.
    >
    > I have setup a system dsn called 'CSC Data Repository'.
    >
    > When the database is opened i have a form open which links to a query.
    > So as it is looking at the odbc linked tables it prompts me for the
    > password each time.
    >
    > Is there a way I can save the odbc password in the database so it
    > doesn't prompt me?
    >
    > Many Thanks!
    >
    > Adam
    >
     
  4. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    Create a passthrough Query (User_Tables)
    SQL: SELECT * FROM INFORMATION_SCHEMA.Tables

    in the connect property add: ODBC;DSN=MyDsn;UID=MyUID;PWD=MyPwd ' + other
    relevant settings

    Open the Query through a recordset before opening your form

    You also can store the pwd if you use DoCmd.TransferDataBase to link the
    tables or Change The Connect Property of the TableDef

    HTH

    Pieter


    "Adam" <adamevans81@gmail.com> wrote in message
    news:1153220373.167538.114550@s13g2000cwa.googlegroups.com...
    > Hi All,
    >
    > I have a database which has a few tables linked to an SQL server.
    >
    > I have setup a system dsn called 'CSC Data Repository'.
    >
    > When the database is opened i have a form open which links to a query.
    > So as it is looking at the odbc linked tables it prompts me for the
    > password each time.
    >
    > Is there a way I can save the odbc password in the database so it
    > doesn't prompt me?
    >
    > Many Thanks!
    >
    > Adam
    >




    --
    ----------------------------------------
    I am using the free version of SPAMfighter for private users.
    It has removed 4285 spam emails to date.
    Paying users do not have this message in their emails.
    Get the free SPAMfighter here: http://www.spamfighter.com/len
     
  5. Adam

    Adam
    Expand Collapse
    Guest

    Ok I've done the pass through query and that works lovely.

    But I'm unsure as to what you mean by 'Open the Query through a
    recordset before opening your form' ? Can you explain this further
    please?



    Pieter Wijnen wrote:

    > Create a passthrough Query (User_Tables)
    > SQL: SELECT * FROM INFORMATION_SCHEMA.Tables
    >
    > in the connect property add: ODBC;DSN=MyDsn;UID=MyUID;PWD=MyPwd ' + other
    > relevant settings
    >
    > Open the Query through a recordset before opening your form
    >
    > You also can store the pwd if you use DoCmd.TransferDataBase to link the
    > tables or Change The Connect Property of the TableDef
    >
    > HTH
    >
    > Pieter
    >
    >
    > "Adam" <adamevans81@gmail.com> wrote in message
    > news:1153220373.167538.114550@s13g2000cwa.googlegroups.com...
    > > Hi All,
    > >
    > > I have a database which has a few tables linked to an SQL server.
    > >
    > > I have setup a system dsn called 'CSC Data Repository'.
    > >
    > > When the database is opened i have a form open which links to a query.
    > > So as it is looking at the odbc linked tables it prompts me for the
    > > password each time.
    > >
    > > Is there a way I can save the odbc password in the database so it
    > > doesn't prompt me?
    > >
    > > Many Thanks!
    > >
    > > Adam
    > >

    >
    >
    >
    > --
    > ----------------------------------------
    > I am using the free version of SPAMfighter for private users.
    > It has removed 4285 spam emails to date.
    > Paying users do not have this message in their emails.
    > Get the free SPAMfighter here: http://www.spamfighter.com/len
     
  6. Adam

    Adam
    Expand Collapse
    Guest

    Ah its ok, i've seen what you've done.

    I managed to get this working! Thank you.

    Adam wrote:

    > Ok I've done the pass through query and that works lovely.
    >
    > But I'm unsure as to what you mean by 'Open the Query through a
    > recordset before opening your form' ? Can you explain this further
    > please?
    >
    >
    >
    > Pieter Wijnen wrote:
    >
    > > Create a passthrough Query (User_Tables)
    > > SQL: SELECT * FROM INFORMATION_SCHEMA.Tables
    > >
    > > in the connect property add: ODBC;DSN=MyDsn;UID=MyUID;PWD=MyPwd ' + other
    > > relevant settings
    > >
    > > Open the Query through a recordset before opening your form
    > >
    > > You also can store the pwd if you use DoCmd.TransferDataBase to link the
    > > tables or Change The Connect Property of the TableDef
    > >
    > > HTH
    > >
    > > Pieter
    > >
    > >
    > > "Adam" <adamevans81@gmail.com> wrote in message
    > > news:1153220373.167538.114550@s13g2000cwa.googlegroups.com...
    > > > Hi All,
    > > >
    > > > I have a database which has a few tables linked to an SQL server.
    > > >
    > > > I have setup a system dsn called 'CSC Data Repository'.
    > > >
    > > > When the database is opened i have a form open which links to a query.
    > > > So as it is looking at the odbc linked tables it prompts me for the
    > > > password each time.
    > > >
    > > > Is there a way I can save the odbc password in the database so it
    > > > doesn't prompt me?
    > > >
    > > > Many Thanks!
    > > >
    > > > Adam
    > > >

    > >
    > >
    > >
    > > --
    > > ----------------------------------------
    > > I am using the free version of SPAMfighter for private users.
    > > It has removed 4285 spam emails to date.
    > > Paying users do not have this message in their emails.
    > > Get the free SPAMfighter here: http://www.spamfighter.com/len
     

Share This Page