Welcome to SPN

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

Sign Up Now!

Use Autoexec to update linked tables.

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

  1. Access Dummy

    Access Dummy
    Expand Collapse
    Guest

    Hopefully someone can help to get this to work.

    I am using Access 2000.

    Most of our data is in a Notes database which I extract into Access using a
    link tables (ODBC). What I want to do is update the tables automatically
    using scheduled tasks and an Autoexec macro.

    The problem I am having is that the scheduled task runs opens the database
    and the macro runs but it stops because it is waiting for the password. Is
    there a way I can save the password to avoid the update "freezing".

    The reason I want to do this is to avoid waiting five to ten minutes for the
    link tables to update when I want to the database.

    Thank you in advance.

    DC
     
  2. Loading...


  3. kerry_ja@yahoo.com

    kerry_ja@yahoo.com
    Expand Collapse
    Guest

    I would try relinking the tables, and checking the box to save the
    password
     
  4. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    or you can use a passthrough query with uid & pwd first to open the
    connection

    Pieter

    "Access Dummy" <Access Dummy@discussions.microsoft.com> wrote in message
    news:E179C263-1C54-4764-A8D7-77C9257E0B11@microsoft.com...
    > Hopefully someone can help to get this to work.
    >
    > I am using Access 2000.
    >
    > Most of our data is in a Notes database which I extract into Access using
    > a
    > link tables (ODBC). What I want to do is update the tables automatically
    > using scheduled tasks and an Autoexec macro.
    >
    > The problem I am having is that the scheduled task runs opens the database
    > and the macro runs but it stops because it is waiting for the password. Is
    > there a way I can save the password to avoid the update "freezing".
    >
    > The reason I want to do this is to avoid waiting five to ten minutes for
    > the
    > link tables to update when I want to the database.
    >
    > Thank you in advance.
    >
    > DC
     

Share This Page