Any mde restrictions for queries?

#11

On Jun 30, 6:50*am, Salad <sa... (AT) oilandvinegar (DOT) com> wrote:

Quote:

David W. Fenton wrote:
Salad <sa... (AT) oilandvinegar (DOT) com> wrote in
news:yKWdnTBCErmJlLTRnZ2dnUVZ_g-dnZ2d (AT) earthlink (DOT) com:

David W. Fenton wrote:

Lay <lightai... (AT) gmail (DOT) com> wrote in
news:b199ec66-5756-4060-8c5e-a3586451c76d (AT) a6g2000pro (DOT) googlegroups.
com
:

On Jun 26, 7:03 am, "David W. Fenton"
XXXuse... (AT) dfenton (DOT) com.invalid> wrote:

Lay <lightai... (AT) gmail (DOT) com> wrote
innews:27bb4b86-0bac-4d4a-b262-ecee97f76

0... (AT) u26g2000yqu (DOT) googlegroups.co

m:

I am using Access 2003 mdb now. I plan to convert it to mde
file for security reasons. May I know if the creation of new
queries and modification of existing queries will be affected
in any way with mde files? Are there any restrictions?

I saw some problems about queries with mde files on the net, so
I got worried.

Do you understand what an MDE is? I don't think you do, or you
wouldn't be asking this question. I suggest you read up on it.

Thank you for all your replies. Pardon my ignorance. I thought
once compiled, the file cannot be changed anymore and read-only.
Now, I know that is wrong. Thank you.

Try reading the help file. Then ask questions based on having
attempted to inform yourself.

It's certainly OK not to understand the brief and pithy content
of the help files.

It's *not* OK to keep blithely asking people to explain it to you
when you don't seem to have even tried to understand it on your
own.

What side of the bed did David wake up on? *The wrong side, it
seems.

Why the anger?

I am not angry. It felt to me like I was being asked to spoonfeed
the answer, and that annoys me.

I also think that anybody who uses MDEs but can't explain what they
are for is someone is not at what I'd call a competent level.

I might have said..create a new mdb. *Add a couple of tables with a
couple of records. *Create a form with a wizard. *Now convert to an mde.
* Open the MDE. *Can you modify the form? *Can you modify the query?
Are you worried now?

Or one doesn't need to answer the question in the first place. * It
isn't personal. *The answer could have be more welcoming or not answered
at all. *I haven't seen any other posts from Lay so the "keep blithely
asking people" line made me wonder what crossed your wires. *Advice like
"Try reading the help file." isn't very helpful. *A pointer to a topic
in the helpfile might be more useful.

To me, an annoying question like me would be "Help, I keep getting a
2617 error. *How do I fix it?" *As if we've all memorized the error
numbers that can be produced in Access.

But this is just my opinion.

Hi Salad and others,

Thank you for your replies. I admit I did not really do my homework
first before asking the question. Anyway, I am paying no one to answer
my questions on this free forum. Yet, most of the time, helpful people
will come forward to answer them. I thank you all. Most technical
forums are full of helpful people (engineers, scientists) who help for
free and this leads to abuse occasionally by people too lazy to do
their homework. I plead guilty as charged.

It is acceptable if impolite replies are made to stupid or lazy
questions like the one I just asked. What is less acceptable is to
make impolite replies but still not answer the question. I think
ignoring the question would be better manners.

#12

Salad <salad (AT) oilandvinegar (DOT) com> wrote in
news:vJWdncAj9tZd5bfRnZ2dnUVZ_uKdnZ2d (AT) earthlink (DOT) com:

Quote:

David W. Fenton wrote:

Salad <salad (AT) oilandvinegar (DOT) com> wrote in
news:yKWdnTBCErmJlLTRnZ2dnUVZ_g-dnZ2d (AT) earthlink (DOT) com:

David W. Fenton wrote:

Lay <lightaiyee (AT) gmail (DOT) com> wrote in
news:b199ec66-5756-4060-8c5e-a3586451c76d (AT) a6g2000pro (DOT) googlegroups
. com:

On Jun 26, 7:03 am, "David W. Fenton"
XXXuse... (AT) dfenton (DOT) com.invalid> wrote:

Lay <lightai... (AT) gmail (DOT) com> wrote
innews:27bb4b86-0bac-4d4a-b262-ecee97f76

097 (AT) u26g2000yqu (DOT) googlegroups.com:

I am using Access 2003 mdb now. I plan to convert it to mde
file for security reasons. May I know if the creation of new
queries and modification of existing queries will be affected
in any way with mde files? Are there any restrictions?

I saw some problems about queries with mde files on the net,
so I got worried.

Do you understand what an MDE is? I don't think you do, or you
wouldn't be asking this question. I suggest you read up on it.

Thank you for all your replies. Pardon my ignorance. I thought
once compiled, the file cannot be changed anymore and
read-only. Now, I know that is wrong. Thank you.

Try reading the help file. Then ask questions based on having
attempted to inform yourself.

It's certainly OK not to understand the brief and pithy content
of the help files.

It's *not* OK to keep blithely asking people to explain it to
you when you don't seem to have even tried to understand it on
your own.

What side of the bed did David wake up on? The wrong side, it
seems.

Why the anger?

I am not angry. It felt to me like I was being asked to spoonfeed
the answer, and that annoys me.

I also think that anybody who uses MDEs but can't explain what
they are for is someone is not at what I'd call a competent
level.

I might have said..create a new mdb. Add a couple of tables with
a couple of records. Create a form with a wizard. Now convert to
an mde.
Open the MDE. Can you modify the form? Can you modify the
query?
Are you worried now?

I'm happy to explain when a good question is asked that reflects
sincere interest in trying to figure out the problem. I see no
evidence of that here.

Quote:

Or one doesn't need to answer the question in the first place.
It isn't personal. The answer could have be more welcoming or not
answered at all. I haven't seen any other posts from Lay so the
"keep blithely asking people" line made me wonder what crossed
your wires.

Read what's quoted above.

He asked the question, I suggested he read up on it enhance his
understanding. He then asked for me to explain it to him. He didn't
say "I read the help file and didn't understand it" -- he just asked
for it to be explained to him.

This is what tripped me off.

Quote:

Advice like
"Try reading the help file." isn't very helpful. A pointer to a
topic in the helpfile might be more useful.

Uh, a topic that gets you the answer is MDE, for instance. If he's
not smart enough to figure that out, he's not smart enough to be
using an MDE.

Quote:

To me, an annoying question like me would be "Help, I keep getting
a 2617 error. How do I fix it?" As if we've all memorized the
error numbers that can be produced in Access.

But it's so easy to type ?AccessError(2617) in the immediate window
and get the answer, that one doesn't bother me as much (though, of
course, I think it's better strategy to include the error message in
your question since many people won't bother to do the little it
takes to look it up).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

#13

Lay <lightaiyee (AT) gmail (DOT) com> wrote in
news:a115d5b9-82f9-4707-b053-9f4fe17fe8dc (AT) e29g2000prn (DOT) googlegroups.co
m:

Quote:

It is acceptable if impolite replies are made to stupid or lazy
questions like the one I just asked. What is less acceptable is to
make impolite replies but still not answer the question. I think
ignoring the question would be better manners.

You admit you asked a lazy question. When it was suggested you read
up on the subject and return after having done so, you basically
conveyed that you were too lazy to do so, and wanted the answer
spoonfed to you.

This seems to me like a not very well-planned tactic for getting
useful answers.

If you'd read the help file, your original question should have been
answered. If it raised further questions, then obviously you could
post back with those questions.

I just can't see how my urging you to do your own homework and
refusing to do it for you is somehow rude on *my* part.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

#14

On Jul 1, 8:54*am, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid>
wrote:

Quote:

Salad <sa... (AT) oilandvinegar (DOT) com> wrote innews:vJWdncAj9tZd5bfRnZ2dnUVZ_uKdnZ2d (AT) earthlink (DOT) com:

David W. Fenton wrote:

Salad <sa... (AT) oilandvinegar (DOT) com> wrote in
news:yKWdnTBCErmJlLTRnZ2dnUVZ_g-dnZ2d (AT) earthlink (DOT) com:

David W. Fenton wrote:

Lay <lightai... (AT) gmail (DOT) com> wrote in
news:b199ec66-5756-4060-8c5e-a3586451c76d (AT) a6g2000pro (DOT) googlegroups
. com:

On Jun 26, 7:03 am, "David W. Fenton"
XXXuse... (AT) dfenton (DOT) com.invalid> wrote:

Lay <lightai... (AT) gmail (DOT) com> wrote
innews:27bb4b86-0bac-4d4a-b262-ecee97f76

0... (AT) u26g2000yqu (DOT) googlegroups.com:

I am using Access 2003 mdb now. I plan to convert it to mde
file for security reasons. May I know if the creation of new
queries and modification of existing queries will be affected
in any way with mde files? Are there any restrictions?

I saw some problems about queries with mde files on the net,
so I got worried.

Do you understand what an MDE is? I don't think you do, or you
wouldn't be asking this question. I suggest you read up on it.

Thank you for all your replies. Pardon my ignorance. I thought
once compiled, the file cannot be changed anymore and
read-only. Now, I know that is wrong. Thank you.

Try reading the help file. Then ask questions based on having
attempted to inform yourself.

It's certainly OK not to understand the brief and pithy content
of the help files.

It's *not* OK to keep blithely asking people to explain it to
you when you don't seem to have even tried to understand it on
your own.

What side of the bed did David wake up on? *The wrong side, it
seems.

Why the anger?

I am not angry. It felt to me like I was being asked to spoonfeed
the answer, and that annoys me.

I also think that anybody who uses MDEs but can't explain what
they are for is someone is not at what I'd call a competent
level.

I might have said..create a new mdb. *Add a couple of tables with
a couple of records. *Create a form with a wizard. *Now convert to
an mde.
* Open the MDE. *Can you modify the form? *Can you modify the
* query?
Are you worried now?

I'm happy to explain when a good question is asked that reflects
sincere interest in trying to figure out the problem. I see no
evidence of that here.

Or one doesn't need to answer the question in the first place. *
It isn't personal. *The answer could have be more welcoming or not
answered at all. *I haven't seen any other posts from Lay so the
"keep blithely asking people" line made me wonder what crossed
your wires.

Read what's quoted above.

He asked the question, I suggested he read up on it enhance his
understanding. He then asked for me to explain it to him. He didn't
say "I read the help file and didn't understand it" -- he just asked
for it to be explained to him.

Hi Mr Fenton,
I never asked you to explain it to me. I just replied with something
like "thank you and pardon my ignorance" which I reproduced below
again.

"Thank you for all your replies. Pardon my ignorance. I thought once
compiled, the file cannot be changed anymore and read-only. Now, I
know that is wrong. Thank you. "

That said, my very first post was a lazy one. I thank you for making
the effort to reply to that as well. I apologise.

Your tone was somewhat justified in a free forum full of helpful
people as there will be people who abuse the helpfulness and ask lazy
questions.

However, as an engineer focused on solving problems, I have learnt
over the years that the tone of discussion should be kept impersonal
and polite so that the team can focus on the problem. When the
atmosphere gets personal with clashing egos, the focus becomes
unproductive like what has happened here. Sorry my very first lazy
question triggered off the personal unproductive atmosphere.

#15

Lay <lightaiyee (AT) gmail (DOT) com> wrote in
news:3af7bafd-ed3c-45a0-bff3-4e5472a7836e (AT) y2g2000pra (DOT) googlegroups.com
:

Quote:

Sorry my very first lazy
question triggered off the personal unproductive atmosphere.

Your fault, not mine. Do your homework before you post and you'll
get much higher quality answers.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

#16

On Jul 2, 3:26*am, "David W. Fenton" <XXXuse... (AT) dfenton (DOT) com.invalid>
wrote:

Quote:

Lay <lightai... (AT) gmail (DOT) com> wrote innews:3af7bafd-ed3c-45a0-bff3-4e5472a7836e (AT) y2g2000pra (DOT) googlegroups.com
:

Sorry my very first lazy
question triggered off the personal unproductive atmosphere.

Your fault, not mine. Do your homework before you post and you'll
get much higher quality answers.

--
David W. Fenton * * * * * * * * *http://www.dfenton.com/
usenet at dfenton dot com * *http://www.dfenton.com/DFA/

Yes, my mistake. Blame accepted. End of story. But continue your good
work in helping newbies which I saw in your other posts.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Any mde restrictions for queries?

comp.databases.ms-access comp.databases.ms-access

Re: Any mde restrictions for queries? - 06-30-2010 , 03:53 AM

Re: Any mde restrictions for queries? - 06-30-2010 , 07:54 PM

Re: Any mde restrictions for queries? - 06-30-2010 , 07:57 PM

Re: Any mde restrictions for queries? - 06-30-2010 , 08:26 PM

Re: Any mde restrictions for queries? - 07-01-2010 , 02:26 PM

Re: Any mde restrictions for queries? - 07-01-2010 , 08:53 PM