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

Posted on 2012-12-26
Medium Priority
Last Modified: 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
Question by:David Bach
  • 2
LVL 11

Expert Comment

by:David Kroll
ID: 38722204
LVL 53

Accepted Solution

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


Author Closing Comment

by:David Bach
ID: 38722238
Greetings gustav;

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

LVL 53

Expert Comment

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


Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

621 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