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

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