QyeryDef.Type dbQCompound

Hi all

Could anyone please tell me what a compound query in Access is?

Of course, I've binged/googled and searched the on-line "help" but didn't find a single clue.

/gustav

PS: It is not just a select query with more than one criteria.
LVL 53
Gustav BrockCIOAsked:
Who is Participating?
 
Gustav BrockConnect With a Mentor CIOAuthor Commented:
I found this:

http://office.microsoft.com/en-in/access-help/HV080753770.aspx

which could indicate that it is (was) a specific situation for an ODBC Direct workspace - but these are no longer are supported.

I then tried to follow the guide, and it is possible to create a pass-through query with a compound set of statements separated by semicolon.

However, when I save such query, it is just marked as a normal pass-through query, and the Type property doesn't indicate compound.

Confusing?

/gustav
0
 
Bill RossConnect With a Mentor Commented:
Hi,

"Could anyone please tell me what a compound query in Access is?"

This is not a common term and there is no query in MS Access sor SQL that is designated as compound.

It could mean a UNION query where 2 or more select queries are combined.

Regards,

Bill
0
 
MacroShadowConnect With a Mentor Commented:
From babylon.com:
compound query

A query that is composed of at least one action query (a query that copies or changes data) and at least one select query (a query that returns a Recordset without changing data). In DAO, a compound query is created by putting two or more SQL statements (separated by semicolons) in the SQL property of a QueryDef object.
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Gustav BrockCIOAuthor Commented:
Thanks, I'm familiar with the word compound and what it could cover in this context.

However, my question is how to create or where to meet an Access QyeryDef with property Type of dbQCompound:

QueryDefTypeEnum Enumeration (DAO)

I've never seen such neither read about it.

/gustav
0
 
Gustav BrockCIOAuthor Commented:
I found an Access 97 help file and it also states something like:
A query that is composed of at least one action query (a query that copies or changes data) and at least one select query (a query that returns a Recordset without changing data). In DAO, a compound query is created by putting two or more SQL statements (separated by semicolons) in the SQL property of a QueryDef object.
However, if I try that, an error is raised that characters are found after the semicolon ...

So, does an example exist?

/gustav
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Gustav ... if you don't know, there is no hope :-)

I've never seen the term in Access ever. Interesting. I discovered a new VBA keyword last week also:

Erase

Check help for details. Has to do with clearing an Array.

mx
0
 
Gustav BrockCIOAuthor Commented:
Well, thanks, but I have my black or at least grey holes. And the now obsolete ODBCdirect workspace is one of them.

Perhaps these compound queries were thought out but never implemented?
At least it is strange that neither Bing or Google returns a single hit on this type constant except the several places where the Enum is listed.

The Erase I faintly recall to have seen but I have never used it.

/gustav
0
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
Never heard the term before either.  I would assume you conjecture is correct; it was related to ODBCDirect Datasources.   There were few (if anyone) that ever used them.

Think I've used a ODBCDirect workspace once in the last twenty years.  I wanted to run a query asynch and that was the only way to do it.

Have heard of Erase though and have used it many times.

Jim.
0
 
Gustav BrockCIOAuthor Commented:
Thanks for your input.

The conclusion seems to be, that this type of query may have been associated with ODBCdirect workspaces only. As these are obsolete now, so is this type of query.

The on-line help, however, is silent about this.

/gustav
0
All Courses

From novice to tech pro — start learning today.