Hello All,

Not sure if this is the right place to put this question, but I figured I'd start here. I have a SQL Server 2000 Database that I can access just fine through code. But when I go to setup an ADP file in Microsoft Access 2000, and I try to create a View, the only thing that shows up when I add a table to the View is All Columns. It doesn't show the columns of the table so that I can select the individual fields. Any ideas as to why this is doing this? I have tried connecting to a different SQL Server machine, and I had no problem selecting specific fields for a query and so forth.

Any ideas?

Thanks,

Jim P.