Results 1 to 6 of 6
  1. #1
    oreo is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2015
    Posts
    3

    problem with linked tables

    Hi all,

    I have a database with linked tables but shows some records as deleted. These records reappear if I press F5

    I have tried to repair the database, update the ODBC driver and does not work

    Someone could help me, thank you !!

  2. #2
    lfpm062010 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Location
    US
    Posts
    415
    Do you have the table open while you or someone "UPDATE/DELETE (not sure about INSERT)" the data in that table?
    If you refresh or close and reopen then those "#Deleted" will disappear.

  3. #3
    oreo is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2015
    Posts
    3
    No, the table is closed, but if I try to modify some records, I get a write conflict error and only I am working with this database
    It is very rare

  4. #4
    lfpm062010 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Location
    US
    Posts
    415
    Not sure if this article will help. http://support.microsoft.com/kb/128809

    Did you try to re-linked the tables?

  5. #5
    oreo is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Mar 2015
    Posts
    3
    Yes, I tried to re-linked the tables and even reinstall office but with the same result.
    In other PC´s works perfectly, just fails in mine

  6. #6
    lfpm062010 is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Oct 2013
    Location
    US
    Posts
    415
    It is strange that you the only one has the issue.
    Does the linked table has an unique key? or did you choose what you think is unique?

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

Similar Threads

  1. Replies: 4
    Last Post: 11-22-2013, 11:20 AM
  2. Replies: 5
    Last Post: 02-02-2012, 06:42 PM
  3. Linked Table Problem
    By annieloux in forum Access
    Replies: 2
    Last Post: 09-22-2011, 01:03 PM
  4. Problem with linked tables
    By meijermartijn in forum Import/Export Data
    Replies: 6
    Last Post: 08-24-2011, 01:48 PM
  5. Linked Picture Problem
    By stepwaec in forum Reports
    Replies: 2
    Last Post: 07-14-2011, 08:38 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