#Deleted displayed in all cells when connecting to SQL Database

J

Jon Paskett

I'm using Access 2003 to gain access to the tables in a SQL 2000 database.
All cell data in Access display #Deleted.

What am I doing wrong?

TIA

Jon
 
A

andrei

Hi Jon,

Are you using linked tables ?
If that's the case, try refreshing the link (Linked Table Manager) or just
delete and recreate the linked table in access.
If this happens for all the tables, you might want to write a procedure to
loop through your tables and refresh the link programmatically.

Andrei.
 
D

Doug Goodenough

Hi Jon,

I just encountered this problem with an Access DB I created. I found the
problem to be with a column in my SQL SERVER table that was defined as type
BIGINT. Access did not recognize this type and when I looked at the table in
access it showed that column as being type TEXT. And when I view the table
in datasheet view all columns showed #deleted. I went in to enterprise
manager and changed the column type to float and now access shows it as
being type number.....problem fixed....all my data now shows correctly in
access. You might want to check to see if access is recognizing all of the
column attributes correctly that you defined in SQL SERVER....good luck

Doug
 
M

MDP

This is the correct answer for this problem.

Doug Goodenough said:
Hi Jon,

I just encountered this problem with an Access DB I created. I found the
problem to be with a column in my SQL SERVER table that was defined as type
BIGINT. Access did not recognize this type and when I looked at the table in
access it showed that column as being type TEXT. And when I view the table
in datasheet view all columns showed #deleted. I went in to enterprise
manager and changed the column type to float and now access shows it as
being type number.....problem fixed....all my data now shows correctly in
access. You might want to check to see if access is recognizing all of the
column attributes correctly that you defined in SQL SERVER....good luck

Doug
Click to expand...
 
Top