Access Linking To SQL Server 2008 Database Table Shows #Deleted In All Columns

David Bach
David Bach used Ask the Experts™
on
Greetings;

I am using Microsoft Access 2010 to link to a Microsoft SQL Server 2008 database. There are 2 tables in the database. Both have primary keys defined.

The first table contains 2 columns defined as varchar(2) and varchar(50). The first is the primary key.

The second table contains 19 columns. The primary key is defined as bigint and auto-increments. Most of the other columns are defined nvarchar(255). 2 of the columns are defined datetime. Some of the columns allow for nulls.

I have an ODBC data source to connect to the external SQL Server database.

When I create an empty Microsoft Access database and select the ODBC data source and tables - I can view and modify the first table, however, the 2nd table comes up with 84 rows of the word #Deleted in each column of each row. There are 84 rows in the second table on the Microsoft SQL Server 2008 database - this number is not a coincidence.

Why is this happening?


Much thanks ... David
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
Access cannot read BigInt. Change this to Int.

/gustav
David BachPartner

Author

Commented:
Greetings gustav;

Much obliged. I changed the data type and it works as expected.

David
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
Great. Happy New Year!

/gustav

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial