Linking SQL tables to Access

[Tracey]

I have table in a sql2000 database which I am attempting
to link using access2000. It appears that any of my sql
tables with an '_'(underscore) in an index related to
them cannot be linked. Tables which dont have any
underscore are linking fine. I can see all my tables.
Is there a setting which I can turn off that will ignore
indexes or allow underscores?

 

[Joe Fallon]

I do not think so.
But all is not lost.
Create a View in SQL Server usng a more acceptable name.
Link to the View.

 

[Tracey]

Ill try that

-----Original Message-----
I do not think so.
But all is not lost.
Create a View in SQL Server usng a more acceptable name.
Link to the View.
--
Joe Fallon
Access MVP






.