Data access, table data display in adp's.

[Mark]

I have an issue with displaying tables in design mode in MS Access to SQL
Server. I have 20 or so tables and most will enable the design view from MS
Access. Most will show their data simply by a dbl click. Others will not.
They do nothing when selected and choose ‘Design’. I also find that creating
a quick view will not show the data. I'm required to use Enterprise Manager.
What causes this?
Access 2002 against SQL Server 2000.
Thanks for the help,
Mark

 

[a a r o n . k e m p f]

why are you 'required' to use Enterprise Manager?
I'd tell them that you're using EM and then use ADP... pretty simple
math.

if they want a script; then go in Enterprise Manager.

what do you mean, 'some will not show their data simply by a dbl
click'
you should give us the error message, i guess.. Is that what you're
seeing?

 

[a a r o n . k e m p f]

btw, do you have enough PERMISSIONS to these tables?

I might guess that if you've got _SOME_ permissions to a table; but
you don't have permissions to one of the system sprocs.. I keep on
wanting to say 'getObjectById' is the name of the sproc I'm thinking
of.. but i know that's not right)

 

[Mark]

I believe all the permissions are the same although some tables display data
and others do not. Sometimes I will get the msg “Stored Procedure ran but did
not return any recordsâ€. If I try again, I get nothing, no msg, no data
display.

 

[a a r o n . k e m p f]

that's called 'setwarnings' right?

I usually make a macro called 'SetWarnings_ON' and 'SetWarnings_Off'
for enabling this property (through the gui).

I just turn those properties on and off so much (programmatically)
i've got to run those macros sometimes for sanity's sake