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...

    Similar Threads Forum Date
    Self Update On The Gurdwara Blogs Apr 3, 2017
    Sikh News BREAKING: Young Sikh Shot Dead In Jalalabad, Afghanistan . - Sikh24 News & Updates Breaking News Oct 2, 2016
    Update Blogs Oct 16, 2015
    Update Wikipedia Enteries On Sikh Socio-Political Topics Breaking News Jul 19, 2015
    Pacific Oil Slicks Spotted In Search For Missing Malaysia Airlines Plane (Live Updates) Breaking News Mar 8, 2014

  3. OP
    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. OP
    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
     
Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     


Share This Page