Data access, table data display in adp's.

  • Thread starter Thread starter Mark
  • Start date Start date
M

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
 
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?
 
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)
 
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.
 
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
 
Back
Top