mde and mdb

[StevenC]

If i distribute mde's on other workstations, will they still be able to
create thier own queries and reports?

 

[Rick Brandt]

If i distribute mde's on other workstations, will they still be able
to create thier own queries and reports?

Queries, yes. Reports, no.

An MDE disallows creation or change to any code-based objects. That
includes Forms, Reports, and Modules.

 

[Tom van Stiphout]

On Tue, 12 Aug 2008 20:34:38 -0500, "Rick Brandt"

Reports, yes.
Users can create their own MDB, link to the tables of your
application, and go to town creating queries and reports, and any
other objects they desire.
We often give clients this option: it keeps the main application
clean, and they still have a good way to create ad-hoc queries and
reports.

-Tom.
Microsoft Access MVP

 

[Tony Toews [MVP]]

Users can create their own MDB, link to the tables of your
application,

In such a situation I create the MDB, link the tables and give it to
them. Users typically don't understand linking. I may also create
some start queries linking commonly used tables.

and go to town creating queries and reports, and any
other objects they desire.
We often give clients this option: it keeps the main application
clean, and they still have a good way to create ad-hoc queries and
reports.

Otherwise I completely agree with you.

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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/