Cannot see the Colums in the "design view" of Queries SQL 2000 and MSAccess 2000(adp)

Cannot see the Colums in the "design view" of Queries. All i see when i want to design a new query is *columns

This happens in only one database, in other databases using same server i can see the colums and can tick them to view then in the query.

In enterprise manager i see all the columns.

Using SQL 2000 and MSAccess 2000

I'm not sure what your exact problem is. Are you saying that in SQL Server Enterprise Manager that all the columns are not displayed in the design a table view? Are these SQL Server tables or have you connected a remote server to Access?

Buck Woody