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
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
David Kroll
http://www.techonthenet.com/access/tables/del_err_linked.php
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Greetings gustav;
Much obliged. I changed the data type and it works as expected.
David
Much obliged. I changed the data type and it works as expected.
David
Great. Happy New Year!
/gustav
/gustav