TmprryQryFrLnkFldsCrtn0123456789

[TarBall]

Searched the internet, these forums and no luck. Can anyone tell me why Access (2003) generates seemingly random queries?

This query shows up now and then in my database: TmprryQryFrLnkFldsCrtn0123456789

If I look at it in SQL View or in design view it is always blank.

What is it? and how can I avoid getting it?

 

[Pat Hartman]

I haven't seen anything named that way. Access does generate hidden querydefs if you use SQL strings as the RecordSource for your forms/reports or as the RowSource for your list/combos.

 

[The_Doc_Man]

First question: Are you using something other than Access as the DB engine? I.e. using Access as front end, something else as back end. Such that you have another vendor's .DLL files running intermixed with Access when you run the OLDB stuff or SQLnet stuff that goes with alternate back-end solutions.

Second question: Have you purchased & installed any third-party packages to do something or another to optimize or add extra functionality to the DB? Like a special editor, a change-tracking program, or something like that?

As Pat says, Access creates queries for you when you have an implied selection - any combination of ordering, filtering, and joining. The last time I looked, though, the names were all kinda weird strings that began with the tilde character (~) and the next character was always something lowercase that indicated where this query originated. Like, a "f" was a form query and an "r" was a report and there were some variations on the theme.

 

[Lightwave]

Ok just found this sounds like the lad came with the same thing that I did.

Do we just live with this query or is there a way of getting around it..