This is a discussion on Access: linked tables invisible within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> I've recently moved a database from mssql2000 on an NT Server machine to mssql2000 running on a Win 2003 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| Thread Tools | |
| Display Modes | |
|
|