Access Linked Table from SQL Shows #Delete-CodePudding

I created this table:

CREATE TABLE [dbo].[dbo_Country]
(
    [Country] [nvarchar](100) NOT NULL,
    [ISO3166Code] [smallint] NULL,
    [CountryEn] [nvarchar](255) NULL,
    [Abriviation] [nvarchar](255) NULL,

    CONSTRAINT [dbo_Country$PrimaryKey] 
        PRIMARY KEY CLUSTERED ([Country] ASC)
                WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, 
                      IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, 
                      ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

Then I linked it to a MS Access database I try to open the table and see the information but see this:

Does anyone have a solution?

CodePudding user response：

#Deleted is normally shown when rows have been deleted in the underlaying database table while the table is open in Access. They may have been deleted by you in another window or by other users. #Deleted will not show initially when you open the table in Access. Type Shift-F9 to requery. The deleted rows should disappear.

CodePudding user response：

Set a default of 0 for the number (ISO3166Code) (update all existing number column to = 0.)

Add a row version column (timestamp - NOT date time).

Re-link your table(s).

This is a long time known issue. With bit fields (or int) as null, then you will get that error. As noted, also add a timestamp column (not a datetime column).