Linking SQL tables to Access

  • Thread starter Thread starter Tracey
  • Start date Start date
T

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?
 
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.
 
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






.
Click to expand...
 
Back
Top