I am trying to design a view in an Access 2000 project linked to a MS SQL Server 7 backend. My problem arises when I add tables to the view. The only field I can see is the "All Columns" field. I cannot select individual fields. This does not happen when I look at the Northwind sample project. It seems like a pemission thing to me but I just can't seem to crack it! Help me please!!! [sig][/sig]