Results 1 to 2 of 2
  1. #1
    kaledev is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2011
    Posts
    20

    Question Error: Could not delete from specified tables


    I am attempting to delete from a linked SQL Server 2008 R2 database... I am able to view the rows to be effected, but when I try to run the query I get the error "Could not delete from specified tables"

    Am I missing something? Thanks!

    Code:
    DELETE dbo_OLDDATA.*
    FROM dbo_OLDDATA INNER JOIN Disputes ON (dbo_OLDDATA.[Equip Nr] = Disputes.[Equip Nr]) AND (dbo_OLDDATA.[Eq Init] = Disputes.[Eq Init]) AND (dbo_OLDDATA.Terminal = Disputes.Terminal) AND (dbo_OLDDATA.Controller = Disputes.Controller) AND (dbo_OLDDATA.[Report Dt] = Disputes.[Report Dt]);

  2. #2
    kaledev is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2011
    Posts
    20
    Very strange problem...but this fixed it:

    http://support.microsoft.com/kb/240098

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

Similar Threads

  1. Replies: 3
    Last Post: 07-16-2010, 12:32 PM
  2. Replies: 7
    Last Post: 11-16-2009, 11:56 AM
  3. Update / delete and recreate access tables
    By metro17 in forum Access
    Replies: 4
    Last Post: 09-23-2009, 04:45 PM
  4. Error while trying to add delete link button.
    By islandboy in forum Access
    Replies: 3
    Last Post: 09-03-2009, 09:32 AM
  5. Could not delete from specified tables.
    By bullwinkle55423 in forum Queries
    Replies: 0
    Last Post: 08-31-2006, 08:14 AM

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