Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Rows showing as #DELETED

Tags:

sql-server

ms-access

I have rows of data in a table showing as #DELETED on one computer when using Access but they are fine in both the SQL database and on other computers using Access. It seems to be only the latest 200 rows. The Access 2007 versions and ODBC MSJet drivers look to be the same & latest on each computer. One suggestion was to change any PK or FK's to int's, but they already are.

Any ideas for a fix for this?

like image 407
Matt Rowles Avatar asked Mar 12 '12 00:03

Matt Rowles

People also ask

Why is Excel showing R1C1?

The R1C1 reference style is useful if you want to compute row and column positions in macros. In the R1C1 style, Excel indicates the location of a cell with an "R" followed by a row number and a "C" followed by a column number.

Why are my Excel rows numbers not letters?

Cause: The default cell reference style (A1), which refers to columns as letters and refers to rows as numbers, was changed. Solution: Clear the R1C1 reference style selection in Excel preferences. On the Excel menu, click Preferences. Clear the Use R1C1 reference style check box.

2 Answers

Consider the use of numeric (18,0) instead of bigint for the primary key data type in SQL. MS Access can resolve the effectively big integer PK if it is set as a numeric data type on the SQL Server side. I ran into this same issue on SQL 2008R2 with Access 2010 where all the rows displayed '#DELETED' when using a bigint PK.

like image 173
eeasterly Avatar answered Nov 03 '22 23:11

eeasterly

There is an option to support the BigInt data type on newer versions of Access. 

File > Options > Current Database > Data Type Support Options

Apply that option and then refresh your table.

Access Support BigInt

like image 36
Painguin Avatar answered Nov 03 '22 23:11

Painguin
Sign in to Comment

Related questions

SQL JSON - How to modify boolean value present in the Json Data
Include row number in query result (SQL Server)
Avoid NULL columns using DEFAULT Empty String
Should I store HTML as nvarchar(MAX) or ntext?
Which version of .NET framework SQL Server supports?
Is there a way to get DateTime value from timestamp type column?
Dynamic SQL not returning results in Access pass-through query
Replace “&lt;” and “&gt;” with “<” and “>” in sql server
How to insert null in datetime type column in sql server
Replace Multiple Strings in SQL Query
Casting Eval("bitValue") as Bool
Update multiple records in SQL
A cursor with the name ... already exists - SQL Server 2008
How does Entity Framework generate a GUID for a primary key value?
Is Guid the best identity datatype for Databases?
Accounting and Database design, storing debit and credit amount
How to insert multiple select statements into a temp table
How to use TAB as column separator in SQLCMD
Creating procedure inside IF section
Most efficient method for adding leading 0's to an int in sql

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!