#deleted in query from linked SQL Table -- sql server (microsoft)

RTL
9/13/2004 1:28:24 PM

Hello all,

Hello,

I posted this in the MS Access forum, but did not get a response. I'm hoping
that someone here will have some input

I have a problem which may just be a config problem. I have linked tables to
a SQL DB view. For all users, it just has INSERT permissions to this
table--except one. This particular user has SELECT permissions among others.
However, when he goes to view the table, it comes back as "#deleted" It's
baffling to me. You can view the data in the Enterprise Manager without
issue--so the data is getting there.

We have deleted the links/relinked...tried new databases--nothing.

We have other SQL databases in the same SQL Server 2000 and can view the
data without trouble. It's just this one and I cannot find the differences.
I am baffled.

Thanks for any advice,

Rich
www.techarts.com

Andrey
9/17/2004 5:02:46 AM

[quoted text, click to view]

I had this problem when using MS SQL viwes linked to access database - when you open this MS SQL
linked view in Access you see all fields #deleted.
Finally, having spent a whole day on this, i found what was the problem - in my SQL view i have a
primary key on UNIQUEIDENTIFIER field, which for some reason wasn't recognized by Access correctly.
So i've added a table's INT column (unique) to the view and it made trick!

Also, i just recalled, it happened only if you opened the view in access, installed on Win98 or
Win2000 machine. If i opened this acess db on XP machine, it worked fine(version of Access was
always the same - access 2000 with all service packs)

So i think that your problem shoud be similar.
Please let me know if you need any further help!

Good luck,

sql server (microsoft) : #deleted in query from linked SQL Table