Results 1 to 3 of 3
  1. #1
    torunsu is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2011
    Posts
    9

    How to avoid updating linked tables every time

    Hi!

    I have an Access 2003 application with some linked tables which are configured to use an ODBC datasource.

    When I wanted to run this application on my PC the first time, I created the odbc data source on my machine and updated all tables to use this data source. The problem is that I have to do this every time I start the application.

    How can I do this one time, and make the application remember it?

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    When you're selecting the tables to link to from the list, there is a checkbox on the bottom right hand corner that says "remember password." Check that box.

  3. #3
    torunsu is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2011
    Posts
    9

    No checkbox

    No, I can't see any checkbox. I am using Access 2003, and when i relink my tables, I rightclick one table, choose linked table manager and select the tables I want to update. Then, I choose "always prompt for new location" and click ok. Then I choose the datasource, type the password, and all tables are refreshed. There is no checkbox...
    I don't think the password is the issue. It just doesn't remember my datasource...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Excel Linked Table not Updating
    By BillH in forum Import/Export Data
    Replies: 1
    Last Post: 06-09-2011, 08:37 AM
  2. avoid relinking linked tables
    By Hobbes29 in forum Import/Export Data
    Replies: 1
    Last Post: 10-01-2010, 11:15 PM
  3. Help with Linked Tables
    By softspoken in forum Forms
    Replies: 22
    Last Post: 03-25-2010, 09:35 AM
  4. Auto-updating fields in linked tables?
    By Leelers in forum Database Design
    Replies: 27
    Last Post: 01-08-2010, 06:23 PM
  5. help with linked tables
    By davidoakley in forum Access
    Replies: 9
    Last Post: 06-17-2009, 05:23 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums