Access: linked tables invisible

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
.

Relevant Pages

  • Re: Restore database goes to error
    ... Can you try restoring the database into a different SQL ... Server machine and try if it is working. ...
    (microsoft.public.sqlserver.msde)
  • Re: record modification dates
    ... UPDATE Test SET ... Because the value of NOWmay differ between server machine and local ... revoke permissions on the table and grant ... via the proc meaning the database programmer is in control. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: SQL Server 2000 connection
    ... I create a login for the Northwind database in the server machine and added ... put a TADOConnection on a form and tried to build a ...
    (borland.public.delphi.database.ado)
  • Re: Disk or Network Error on Large Access Database
    ... perhaps connection is too slow and timeout occurred? ... database that is running on a Windows 2000 Server Machine using a web ... application that is running IIS 6 or IIS 5. ... The Database I'm trying to ...
    (microsoft.public.access.modulesdaovba)
  • Re: Cant query linked Access database specified by UNC
    ... SH> The first is to do is ensure that the database is not being ... server machine, with the same userid as sqlserver; ... In other words, I manually did exactly what sql server couldn't do, with the ... same login id on the same machine. ...
    (microsoft.public.sqlserver.security)
Loading