Access Linking To SQL Server 2008 Database Table Shows #Deleted In All Columns
Posted on 2012-12-26
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