By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,806 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?
Nov 12 '05 #2

P: n/a
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.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.