Re: Get External Access data

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

Addition:
Any Select query that relies on the value of a Control on an open
Form would also fail the "available external data" test (again, Access, and
the Form, would have to be open for the query to work).

HTH,



"George Nicholson" <GeorgeNJunk@xxxxxxxxxxx> wrote in message
news:u8%23fPFM8HHA.1164@xxxxxxxxxxxxxxxxxxxxxxx
Not sure about 2007, but prior versions worked like this:
Generally, queries are of 2 types: "Action" queries and Select queries

Action queries are those that change data: Update, Append, Delete,
MakeTable, etc. These do not "return" data, per se, just do something to
the data.
Select queries simply filter & present existing data. They provide
"views" of the data. Select, Union and Crosstab queries would fall under
this heading.

Since only Select queries return data, they would be the only "external
data" candidates.

In addition, if a query utilizes a user-defined function (i.e., a
custom function within an Access code module), it won't be listed since
the function would require Access to be open in order for the query to run
properly, and the specific wizard isn't prepared to handle that. (However,
it could still be imported into Excel via automation using code.) I seem
to recall that the use of NZ() within a query would also make it fail this
test since NZ is an Access function (and I think the only Access
function). DAO, ADO and VB functions would all be permissable, iirc.

HTH,


"BBran" <bbran@xxxxxxxxxxx> wrote in message
news:O%23f5S8A8HHA.4436@xxxxxxxxxxxxxxxxxxxxxxx
Hello,

I am using Office 2007 on XP SP2. I am trying to get external Access
data from a database. When I do a window comes up with Access Tables and
Queries (referred to in the window as View) in it. However, not all the
queries are listed. What determines whether a query is listed or not?
There is one I need that is not listed.

Bob





.

Relevant Pages

  • Re: Different MSSQL output date format from the same PHP script
    ... Especially when "SELECT *" queries just do have their uses. ... This is where ORM and "SELECT *" queries are of great value. ... You wouldn't want to ever want to, say, run a query returning all ... will fail, ...
    (comp.lang.php)
  • Access queries have very bad manners
    ... In my long queries, if my screensaver comes on, or I open a new window (say ... the Access window does not repaint until the query has ... I am curious as to how the progress bar at the ...
    (microsoft.public.access.queries)
  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)
  • Re: Was: what does "serialization" mean?
    ... > the specific queries up front. ... that the NEXT time the query is run the query is fast, ... data base, don't know squat" when in fact the Donald clone doesn't ... >> WHATEVER would probably be a separate query to summarize total sales. ...
    (comp.programming)
  • Re: Official Status of SQLServer 2005 ADP
    ... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
    (microsoft.public.access.adp.sqlserver)