Results 1 to 4 of 4
  1. #1
    bbbeng is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    8

    linked table refresh in 2010 not working in 2000

    Hi everyone. Thank you in advance for any ideas ... I have an access db that links to a Pervasive database. I administer the database in 2010 version but one of my user is still on 2000 (he wont change so thats not an option). I had to change the ODBC for a small group of tables. The links are working on my end but not his - he gets an ODBC error.

    Any ideas on why this is happening and how to resolve it? Thanks!

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Yep, it is likely because of the way the newer version links ODBC. You will need to link from 2000 to make it work for him. And, if he won't change, then soon he will be in serious trouble because there will be a point in time where it will not work for him at all. I can understand not wanting to change, but change does happen and these things move forward.

    The only real way to make this work consistently, would be to keep EVERYONE on 2000 and not have anyone upgraded until it was a necessity due to the operating system not supporting it anymore.

  3. #3
    bbbeng is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011
    Posts
    8
    Thank you for the quick response!

    I need to convince him to upgrade I guess ...

  4. #4
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Quote Originally Posted by bbbeng View Post
    Thank you for the quick response!

    I need to convince him to upgrade I guess ...
    Well, one argument to him, "you won't be able to use the database" and if it is something crucial then the incentive might be there.

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

Similar Threads

  1. Access 2010 Refresh VS Refresh ALL
    By Snwboarder1982 in forum Access
    Replies: 1
    Last Post: 09-09-2011, 04:07 PM
  2. Linked table manager in Access 2010
    By Delta223 in forum Access
    Replies: 3
    Last Post: 01-07-2011, 12:37 PM
  3. linked table long query not working
    By mirthcyy in forum Queries
    Replies: 4
    Last Post: 09-23-2010, 03:16 PM
  4. Office 2010 and linked table manager Help
    By bobfin in forum Access
    Replies: 8
    Last Post: 08-05-2010, 07:15 PM
  5. Linked table to sql 2000 db
    By tcroninstl in forum Access
    Replies: 1
    Last Post: 03-23-2009, 07:27 PM

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