ADP connect to SQL 2000 is hiding columns

D

dbahooker

so i have this table that has maybe 100 columns; when i connect to it
via an ADp it only shows like 15 of the 100 columns

all the columns are decimal and char.. it's not like this has changed
recently or anything.. im just confused about why it's showing the
table incorrectly

ps - i have one Access 2000 machine and one Access 2002 machine and it
happens on both
 
A

A C

so i have this table that has maybe 100 columns; when i connect to it
via an ADp it only shows like 15 of the 100 columns

all the columns are decimal and char.. it's not like this has changed
recently or anything.. im just confused about why it's showing the
table incorrectly

ps - i have one Access 2000 machine and one Access 2002 machine and it
happens on both
Click to expand...

Check the permissions on columns in the SQL Server, you will need to do this
via SQL Server. You can hide certain cols from certain users. This could
be the problem
 
D

dbahooker

im sa sorry... seems like it's a bug somehow

i tried with sa; and i tried with domain admin.. something else fishy
is going on
 
D

dbahooker

and just for the record.. yes.. ADP.. as in Access Data Projects..

the best data entry platform for SQL Server; anywhere in the world
 
Top