"#Name?" in all the fields with a linked table in Access from SQL Server

[malibu65k]

I'm linked to an SQL Server using MS Access. All the tables are linked to the same db and I can open and view the data in all the tables except one. All the fields for all the records show #NAME?. I first get an ODBC - Call failed! Then the table opens and I get all the #NAME? in the records. I re-link several times and I still get the same thing.

Any ideas?

Thanks!

 

[dhookom]

Does the table have a primary key defined that Access has identified?
What do you see if you create a pass-through query to the same table?

Duane
Hook'D on Access
MS Access MVP

 

[malibu65k]

It has a primary key set to Autonumber. When I try to select from the table in SQL Server Management environment I get and error...

Msg 916, Level 14, State 1, Line2
Server user '%s' is not a valid user in database '%s'

But I am a valid user, the table is in the same database as the others and the others I have no problem accessing. Why would I be able to access all of them except one?

Thanks!

 

[PHV]

So, this is clearly a SQL Server problem, not an access one.
You may have better answers in one of the SQL Server fora here.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[malibu65k]

Thanks!