|
Home > Archive > MS SQL Server > October 2006 > Why the client cannot see the new columns?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Why the client cannot see the new columns?
|
|
|
| Hi,
Per a request from a client, I added a few new columns to one of their
tables. In both the table and column permissions, I don't see these new
columns have any different permissions than other existing columns. But the
client said he was not able to see the new columns even after he tried to
relink to the table. I guess he was using MS Access.
I've never heard of such kind of problems. Could the table structure be
cached on the client's computer? This is not the first time I added columns
for them. But it's the first time for this person. Can anybody shed some
light what might be the cause?
Thanks in advance,
Bing
| |
| Tibor Karaszi 2006-10-24, 6:33 pm |
| One reason could be that the client is actually accessing the data through a view. Look up
sp_refreshview.
If that isn't the case, then it is an Access issue. I'd give it a shot in the Access groups.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
"bing" <bing@discussions.microsoft.com> wrote in message
news:912440AF-B083-4814-AD82- CD0A65078AAE@microso
ft.com...
> Hi,
>
> Per a request from a client, I added a few new columns to one of their
> tables. In both the table and column permissions, I don't see these new
> columns have any different permissions than other existing columns. But the
> client said he was not able to see the new columns even after he tried to
> relink to the table. I guess he was using MS Access.
>
> I've never heard of such kind of problems. Could the table structure be
> cached on the client's computer? This is not the first time I added columns
> for them. But it's the first time for this person. Can anybody shed some
> light what might be the cause?
>
> Thanks in advance,
>
> Bing
| |
|
| "Tibor Karaszi" wrote:
> One reason could be that the client is actually accessing the data through a view. Look up
> sp_refreshview.
>
> If that isn't the case, then it is an Access issue. I'd give it a shot in the Access groups.
Thanks, Tibor. That's a good point that I did not think of. I just
checked and did not see a view for the table.
Bing
Bing
|
|
|
|
|