Solved

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

Posted on 2012-12-26
4
577 Views
Last Modified: 2012-12-26
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
0
Comment
Question by:David Bach
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 11

Expert Comment

by:David Kroll
ID: 38722204
0
 
LVL 50

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 38722205
Access cannot read BigInt. Change this to Int.

/gustav
0
 

Author Closing Comment

by:David Bach
ID: 38722238
Greetings gustav;

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

David
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 38722287
Great. Happy New Year!

/gustav
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question