.ADP SQL TABLES SHOW IN ACCESS BUT SOME WILL NOT SHOW RECORDS

D

Derek Walton

I have a SQL 2000 database that I want an .ADP view of from Access 2002. For
the most part it works fine but I have a few tables where: when I try to
browse the records under the Tables tab, the first time gives the message
"Stored procedure executed but did not return any records" after that
Access completely ingnores any attempts to open the affected tables - no
message, no action!
The problem flows through to the query section also, allowing the selection
of the table but not returning records on execution!
I've tried repair and creating new a .adp all to no avail.
This has cost me major development time has anyone got any answers?
 
M

Malcolm Cook

ok - you're up to snuff on MDAC then. That is where I am, also on XP.

Happens only on a few tables, huh?

Strange.

Maybe try using sql profiler to start a trace? then compare sql adp is
generating between a normal and a 'ghost' table?

I wondered if some odd combination of grants might result in your behaviour
but could not create it (though, some odd things happen if you grant select
on the table but deny select on all underlying columns to the table...)

--Malcolm
 
Top