Any mde restrictions for queries?

#1

Dear Access experts,

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. Thank you in advance.

#2

On Fri, 25 Jun 2010 01:26:20 -0700 (PDT), Lay <lightaiyee (AT) gmail (DOT) com>
wrote:

What did you read? Do you have a link?

No, there are no restrictions with regards to queries.

-Tom.
Microsoft Access MVP

Quote:

Dear Access experts,

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. Thank you in advance.

#3

Lay <lightaiyee (AT) gmail (DOT) com> wrote in
news:27bb4b86-0bac-4d4a-b262-ecee97f76097 (AT) u26g2000yqu (DOT) googlegroups.co
m:

Quote:

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.

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

#4

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

Quote:

Lay <lightai... (AT) gmail (DOT) com> wrote innews:27bb4b86-0bac-4d4a-b262-ecee97f76097 (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.

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

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.

#5

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

Quote:

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.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.

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

#6

David W. Fenton wrote:

Quote:

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.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?

#7

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

Quote:

Why the anger?

Hi Salad. You've been around this forum for more than 5 minutes. You
should know that's David's normal mode of communication. :-)

#8

Salad wrote:

Quote:

David W. Fenton wrote:

Why the anger?

What anger? Maybe some justifiable impatience, but I fail to see anger.

#9

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

Quote:

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.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.

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

#10

David W. Fenton wrote:

Quote:

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.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.