|
Home > Archive > MS SQL Server ODBC > May 2005 > Access: linked tables invisible
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Access: linked tables invisible
|
|
| Richard 2005-05-06, 7:23 am |
| I've recently moved a database from mssql2000 on an NT Server machine
to mssql2000 running on a Win 2003 Server machine.
Now, when I try to use Access 2002 to Link an sql table, the Access
wizard isn't showing any of the sql tables. In fact, it only shows a
couple of the system tables: dbo.sysconstraints & dbo.syssegments and
one of the views in the database.
I'm using odbc to connect Access to the SQL Server. Everyting else
seems to work ok.
Could anyone suggest whats wrong here, or how to go about finding out
whats wrong?
regards
Richard
| |
| Richard 2005-05-06, 7:23 am |
| On Fri, 06 May 2005 09:01:29 +0100, Richard <richard@softmode.net>
wrote:
mssql2000 running on a Win 2003 Server machine.
>
>Now, when I try to use Access 2002 to Link an sql table, the Access
>wizard isn't showing any of the sql tables. In fact, it only shows a
>couple of the system tables: dbo.sysconstraints & dbo.syssegments and
>one of the views in the database.
>
Problem solved by installing latest mdac on workstation.
Richard
|
|
|
|
|