Did you find a solution? Thanks.

Thank you for replying. I very much appreciate the time you guys take to help.

My use of "Grant ALTER on schema::dbo to testrole" I found to be necessary. Without it,...

I think this is the issue which led immediately to its resolution. Here is the definition of a typical table on my SQL Server box:

CREATE TABLE Request_Activity

(

...

I think this is the issue which led immediately to its resolution. Here is the definition of a typical table on my SQL Server box:

[font="Courier New"]CREATE TABLE Request_Activity

(

...

WendellB (7/6/2011)

---

I use this same scenario with a number of different clients, some using Access 2003, some using 2007 and some using 2010, so I don't think it is an...

WendellB (7/6/2011)

---

Did you create a System DSN or a User DSN on her PC? I've seen this happen occasionally when a System DSN was used. If that is...

I have the same problem trying to run a remote query from 2005 to a 2000 server:

select * from SERVER_2000.some_db.dbo.table_2000

Msg 7314, Level 16, State 1, Line 1

The OLE DB provider...

>Just out of interest, what happens if you try to expand the Linked Server Catalogs in SSMS Object Explorer?

I can see all of the tables in the schema.

entity_name permission_name

dbo.Test2005Table SELECT

dbo.Test2005Table ...

Tried it - same error:

Msg 7313, Level 16, State 1, Line 1

An invalid schema or catalog was specified for the provider "SQLNCLI10" for linked server "SERVER_2005".

This still works after:

select...

Yes, I did. I still get the error message

Msg 7313, Level 16, State 1, Line 1

An invalid schema or catalog was specified for the provider "SQLNCLI10" for linked server "SERVER_2005".