Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 13th, 2007, 11:43 PM
Authorized User
 
Join Date: Jun 2006
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default ODBC linked table showing old data (not refreshing

G'day,

Our department uses MS Access as a front-end to connect to tables in a DB2 back-end.

When data is updated in the DB2 tables, MS Access sometimes appears to display old data.
To refresh the data in MS Access, the ODBC linked table needs to be deleted and then re-linked.

One would think ODBC is only a connection / link and will display whatever is stored in the source table, not somehow retain old data from a previous version of the table.

Has anyone else encountered this?
Any ideas for a fix, setting that needs to be changed?

Environment:
MS Office Access 2003 SP2
IBM DB2 ODBC Driver 7.01.00.40
Windows XP


Thanks,
Dustin
 
Old November 14th, 2007, 12:03 AM
Authorized User
 
Join Date: Jun 2006
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Further to this, when I say that it only occurs 'sometimes', after discussing with a colleague I think the common thing we did notice was that it occurs for the tables that have been dropped and then re-created when being loaded.

I still don't understand how an ODBC link can even remember the old values stored in a table though.

Any advice appreciated.
Thank-you.
 
Old November 14th, 2007, 09:22 AM
Friend of Wrox
 
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

Okay, the second post clears this up. Whenever the tables change on a back end, the linked table manager needs to be refreshed. I can look up how to automate this, but basically instead of unlinking and relinking, right click on the table, select Linked Table Manager, check the check box next to the tables, and then update the links.

It is not an ODBC issue, but this linked table manager issue.

Let me know if you need more help on this.


mmcdonal

Look it up at: http://wrox.books24x7.com
 
Old November 14th, 2007, 05:56 PM
Authorized User
 
Join Date: Jun 2006
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for your help mmcdonal.
:)


Cheers,
Dustin





Similar Threads
Thread Thread Starter Forum Replies Last Post
Linked Images in Firefox Showing Underline kwilliams CSS Cascading Style Sheets 1 March 27th, 2008 03:01 PM
ODBC Linked Table shows #Deleted in all fields Darron Michael Access 4 December 16th, 2005 03:00 PM
ODBC - insert on a linked field - [microsoft][ODBC chimp MySQL 0 April 7th, 2005 04:44 AM
Data has changed error with linked ODBC table Wim Leys Access 7 June 8th, 2004 06:05 AM
Access - Linked ODBC Tables Ben Access 0 July 24th, 2003 10:39 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.