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
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
Last Comment
Gustav Brock
http://www.techonthenet.com/access/tables/del_err_linked.php
ASKER CERTIFIED SOLUTION
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
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 questionASKER
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
Your help has saved me hundreds of hours of internet surfing.
fblack61