Every cell shows #Deleted

Question

I have a  SQL database table that works fine.  I know this because multiple applications use it and all of them work fine.  I also use SQL Server Management Studio to examine it.  However, Access shows "#Deleted" in every cell.  I deleted this linked table, then added it back, but the problem remains the same.

Any tip will be greatly appreciated.

Answer 1

This happens if the table uses data types that Access can't work with. It's unfortunate that these two products from the same company are not kept more in sync. Let MSFT know how you feel about that.

Answer 2

I'm getting *INCORRECT SYNTAX* error, can you please confirm that is the query you are running,

Answer 3

Yes, it has a primary key.  No, it does not have a Date/Time stamp.

The query to crate that table is as following:

CREATE TABLE [dbo].[GeoLiteCity-Blocks](

[startIpNum] [bigint] NOT NULL,

[endIpNum] [bigint] NOT NULL,

[locId] [bigint] NULL,

CONSTRAINT [PK_GeoLiteCity-Blocks] PRIMARY KEY CLUSTERED

(

[startIpNum] ASC,

[endIpNum] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

Answer 4

Does the table have a Primary Key and a Date/Time stamp?

Answer 5

Thank you, Tom.

All of them are bigint in the SQL database table.  I thought it worked before but I upgraded Access a few times and I could be wrong.

Hong