Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5

    Answered: #Deleted All Access versions with SQL 2012

    Hi all - New problem

    I have Access 97, 2010 and 2013

    When i create a DSN to SQL 2012 in any of these versions - I see my tables.

    But when ever I open these tables all i see is the #deleted

    The row or record count is correct but every field says #deleted. If I use a standard Access query - same result

    If I use a passthrough - I see the data

    If I open a table and see all the #deleted records - i can still enter a row of data but a refresh changes the row to #deleted

    If i run a make table query the records are written into a local table and the data is viewable.

    Any Ideas?
    Dale Houston, TX

  2. Best Answer
    Posted by axsprog

    "I figured it out!

    Bigint field on primary key causing behavior"


  3. #2
    Join Date
    May 2003
    Location
    Dallas
    Posts
    817
    Provided Answers: 5

    answered

    I figured it out!

    Bigint field on primary key causing behavior
    Dale Houston, TX

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •