Avatar of David Bach
David Bach
Flag for United States of America asked on

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

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
Microsoft Access

Avatar of undefined
Last Comment
Gustav Brock

8/22/2022 - Mon
David Kroll

ASKER CERTIFIED SOLUTION
Gustav Brock

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
David Bach

ASKER
Greetings gustav;

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

David
Gustav Brock

Great. Happy New Year!

/gustav
Your help has saved me hundreds of hours of internet surfing.
fblack61