Access 2002: another bug?

[=?windows-1250?Q?Vladim=EDr_Cvajniga?=]

Hi,

in my A2002 project I've dicovered a query named
TmprryQryFrLnkFldsCrtn0123456789. I'm sure I have not created it.
?currentdb.QueryDefs("TmprryQryFrLnkFldsCrtn0123456789").SQL
SELECT;

What is it? Why did it happen? How do I avoid such behaviour? I don't need
such queries in my project!

TIA

Vlado

 

[Todos Menos [MSFT]]

do you mean Accesss Data Project?

why in the hell are you using DAO, are you a retard as well as a
foreigner?

I didn't know that they had retards in Russia

 

[Larry Linson]

in my A2002 project I've dicovered a query named
TmprryQryFrLnkFldsCrtn0123456789. I'm sure I have not created it.
?currentdb.QueryDefs("TmprryQryFrLnkFldsCrtn0123456789").SQL
SELECT;

What is it? Why did it happen? How do I avoid such behaviour?

I don't need such queries in my project!

How do you know you don't? Lots of people thought they didn't need all
those tables whose names begin with MSys, either, and were frustrated when
they weren't allowed to delete them. (MSys... tables are Access system
tables, contain vital information, and your application would crash without
them.)

In certain circumstances, Access will create a Query when you use SQL in a
RecordSource, do the "preparation" of the execution plan (sometimes called
"compile the query") and save it. What you show does not appear to be named
the way I remember those being named, but I haven't looked for several
versions of the product. But, as Microsoft does not publish much about
Access / Jet internals, I wouldn't know if they've changed the way they name
those, or if this is something else.

Larry Linson
Microsoft Access MVP

 

[=?windows-1250?Q?Vladim=EDr_Cvajniga?=]

MSys* is totally different kind of stuff. If Access creates "service"
queries they should be hidden, at least.
Vlado

 

[Todos Menos [MSFT]]

just use Acccess Data Proejcts and ADO

DAO has been obsolete for a decade

are you retarded?

DAO hasn't been included with windows, office or mdac for a decade

Stalin should have sent you to Siberia, dipshit

 

[Larry Linson]

MSys* is totally different kind of stuff. If Access creates "service"
queries they should be hidden, at least.

They are... you have to go to some lengths to find them.

That's why I could only suggest you not be so certain that you don't need
"that kind of query in your application." If you were not the sole author
of the database in question, perhaps your database did generate the Query,
if you are the sole author, I don't have a good guess as to where it came
from.

You do have strong opinions about what the product should and should not do.
I hope you find one that fits your desires.

Larry Linson
Microsoft Access MVP

 

[=?windows-1250?Q?Vladim=EDr_Cvajniga?=]

TYVM for your respond.
I have designed the database. I have not designed the query. It must be an
A2002 bug.

Vlado

 

[Todos Menos [MSFT]]

you are correct, it is an Access MDB bug.

Access MDB is non-stop bugs.

Anyone using a piece of shit database should be fired and then spit
upon

-Aaron

 

[Tony Toews [MVP]]

" T o d o s M e n o s [ M S F T ]" < t o d o s _ m e n o s _ m s f t @hotmail.com>
wrote:

<snip>

Note that this person is really A a r o n K e m p f and that he is not an employee
of Microsoft.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Todos Menos [MSFT]]

note that Tony Toews is a MDB-sissy pants

anyone using MDB should be fired and then spit upon

 

[Todos Menos [MSFT]]

Larry

vlad has balls unlike you, you ****ing mdb pussy

lose the training wheels your ****ing losers



MDB sucks balls
ADP won the war