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.
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.