If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Invisible" Columns in ACCESS table
I have a table that I've imported to Access 2002 SP3 from SQL Server 2000,
and I cannot get two of the columns to display. I've looked in the design window and at properties, but I see no reason why these two columns shouldn't display. In a query, I can assign criteria to either column and the results will be affected by it, but the column will not show up. A qurey on just one of those columns gives me an empty display. I can see them in SQL Server's Enterprise Manager, in the original table. Anyone have a similar problem with a solution? -- Harry E Vermillion IT2 Division of Wildlife State of Colorado |
#2
|
|||
|
|||
"Invisible" Columns in ACCESS table
Harry V wrote:
I have a table that I've imported to Access 2002 SP3 from SQL Server 2000, and I cannot get two of the columns to display. I've looked in the design window and at properties, but I see no reason why these two columns shouldn't display. In a query, I can assign criteria to either column and the results will be affected by it, but the column will not show up. A qurey on just one of those columns gives me an empty display. I can see them in SQL Server's Enterprise Manager, in the original table. Anyone have a similar problem with a solution? While looking at the table datasheet go to the menu bar... Format - Unhide Columns -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
#3
|
|||
|
|||
"Invisible" Columns in ACCESS table
Thank you, that did the trick. Now I have to find out who the wise guy was...
-- Harry E Vermillion IT2 Division of Wildlife State of Colorado "Rick Brandt" wrote: Harry V wrote: I have a table that I've imported to Access 2002 SP3 from SQL Server 2000, and I cannot get two of the columns to display. I've looked in the design window and at properties, but I see no reason why these two columns shouldn't display. In a query, I can assign criteria to either column and the results will be affected by it, but the column will not show up. A qurey on just one of those columns gives me an empty display. I can see them in SQL Server's Enterprise Manager, in the original table. Anyone have a similar problem with a solution? While looking at the table datasheet go to the menu bar... Format - Unhide Columns -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com |
Thread Tools | |
Display Modes | |
|
|