File/Get Data won't attach to a SQL table.

[Bob C.]

In Access 97, I am trying to attach to a table in my SQL Server 2000
db.

I use File/Get Data, which displays all the SQL tables including the
one I can't attach to. (I can attach to all the other SQL tables.)

But, when I select that table I get a message that tells me the name
is invalid. I don't understand this because it gives me the name in
the Get Data dialog, and I don't have to enter it manually.

Any ideas?

Thanks,

Bob C.

[Trevor Best]

Bob C. wrote:

In Access 97, I am trying to attach to a table in my SQL Server 2000
db.

I use File/Get Data, which displays all the SQL tables including the
one I can't attach to. (I can attach to all the other SQL tables.)

But, when I select that table I get a message that tells me the name
is invalid. I don't understand this because it gives me the name in
the Get Data dialog, and I don't have to enter it manually.

Throw us a bone :-) What is the name of the table?

[Bob C.]

The table name is "CommunityCommissionDetail".

Among the possible problems listed in the message, the only one that
made any sense was: filename may be too long.

But, I have two tables with slightly longer names that attached and
work just fine.

Thanks.

Bob C.