Re: Listing objects (tables and queries) within a query

Tech-Archive recommends: Speed Up your PC by fixing your registry

Thanks for the reply, Alex.

I think what I am trying to do is different and probably can't be done.

I have a number of queries (out of a 1,000) that have a problem with a join
that involves (2) tables. I'm trying to identify which queries need to be
fixed. However, I don't think listing the objects within a query can be done
except for some type of text search on the qdf.SQL property.

If you can help, the larger issue here is that one of the two tables is a
local MS-Access table and the other is a linked SQL Server db table. The
local table always has lower case codes and the SQL Server table can have a
mixture of codes. Case sensitiviy is enforced on the SQL Server table.
Sometimes the linked records are retrieved, sometimes not and I can't begin
to explain why.

I need to retrieve the matched records somehow.

My aplogies for the double-post here
Jim

"Alex Dybenko" <alexdyb@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23SN9XmhpIHA.3456@xxxxxxxxxxxxxxxxxxxxxxx
Like this:

SELECT MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Type In (1,5,4)

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

"JimP" <jpockmire@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:hdCdnQoQnp-uC43VnZ2dnUVZ_h-vnZ2d@xxxxxxxxxxxxxx
Is there a way to list the objects in a query via code?




.

Relevant Pages

  • Re: Listing objects (tables and queries) within a query
    ... I have a number of queries that have a problem with a join ... local MS-Access table and the other is a linked SQL Server db table. ... I need to retrieve the matched records somehow. ... the tables in the from clause and any additional fields in the where, ...
    (microsoft.public.access.modulesdaovba)
  • Re: Listing objects (tables and queries) within a query
    ... local MS-Access table and the other is a linked SQL Server db table. ... have a mixture of codes. ... I need to retrieve the matched records somehow. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Listing objects (tables and queries) within a query
    ... You can try to import sql server table to access, then make join, whatever, and then update sql server table based on primary key ... I need to retrieve the matched records somehow. ... "Alex Dybenko" wrote in message ...
    (microsoft.public.access.modulesdaovba)
  • Re: The best elegant solution to override 65k rows limit in a sheet
    ... Access ships with MSDE.. ... >SQL Server Books Online (again-- Access ships with freeware SQL Server ... better ways to achieve their results through queries. ...
    (microsoft.public.excel)
  • Re: Official Status of SQLServer 2005 ADP
    ... solution might be to use ADP. ... With MDB and Linked tables, the only ways of accelerating things are the use ... of Views and the cumbersome use of SQL passthrough queries. ... > SQL Server, and carry on using Access like I aways had. ...
    (microsoft.public.access.adp.sqlserver)