SLQ Server linked table would not show one field in access db

[Katya85S]

In access application i have SQL Server linked tables. A couple of fields, and i can see them in SQL Server EM, does not show up in the linked table in MS Access. But i need those fields in my queries. What do i do?
In QA i found that those fields have constrains:
[update_type] [int] NOT NULL CONSTRAINT [DF__tblName__updat__2C81A546] DEFAULT (0)

There is another linked SQL Server table with the same kind of constrain on a field, and I can see that field from MS Access with no problem.
Any idea on how can i use that "invisible" field in my Access project?
I would appreciate any help.
Thank you all in advance.

 

[Katya85S]

I think, the problem is - the table is too long. Now i see that those are last fields, 10 or may be more, that are not shown in the linked table, and the field i need for my query is one of them... If we could select only fields we need in the linked table, that probably could be a solution, as i need just a few fields (and one of those happen to be one of teh last fields in teh table)...

 

[dhookom]

Did you refresh the link to the SQL Server? How many fields do you have in your table?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Katya85S]

Too many. It might be something about 100. More or less. I don't know if we can count number of fields in the table via sql code, but I would hasitate to count them manually. I see though, as i've said in my message, that last 10 or 20 fields were not caried over in a linked table. So, yes, the problem is in teh number of fields in teh table.
I found a solution, though: instead of linking teh table i've created View (with only fields i need) and linked that View to teh Access database. It seems working fine
Thank you dhookom for looking into this and your time.

 

[dhookom]

You can have up to 255 fields linked from any datasource. "about 100" would not be an issue. Usually the cause of not seeing fields in Access is the fields were added to the server table after the table was linked into Access. That's why I asked if you tried to "refresh the link to the SQL Server".

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[Katya85S]

And you were right. After your answer I managed myself to count field numbers. Yes, there are more then 255 fields in that table.

 

[dhookom]

IMHO more than about 25 fields in any table is too many and suggests an unnormalized database. I could be wrong ;-)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]