#Deleted appears in all SQL2000 linked tables in Access2003 -- sql server connect

Seth
4/11/2006 5:39:01 AM

I have a database on a SQL2000 server that I am trying to connect for viewing
in Access 2003 with the client running Windows 2000. I have created the
connection, but when I try to view the tables, I get "#Deleted" in all the
rows, for both tables. I installed the latest MS Jet Driver to no avail. I
also stumbled upon a posting stating that Access does not recognize BigInt as
a UID. Is this correct? Is there a workaround without having to mod the SQL
tables? I can open the tables fine with Sun's OpenOffice. Any help greatly

Sue Hoegemeier
4/11/2006 8:05:45 PM

It's an Access issue that can be caused by several things
such as using a float as the index or as part of the index
or having nulls as values in part of the index. And there
was an issue when using Bigints with some data sources as
well which wouldn't map correctly but that was corrected in
one of the Jet service packs. Make sure you have the latest
service pack for Jet.

-Sue

On Tue, 11 Apr 2006 05:39:01 -0700, Seth
[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server connect

sql server connect : #Deleted appears in all SQL2000 linked tables in Access2003