Re: [MS_AccessPros] Stored Queries vs. Record Source

 

Adam-

See answers below.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Apr 1, 2015, at 6:30 PM, runuphillracing@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

What are the pros/cons of using stored queries for forms and reports vs. writing the sql in the record source property? Historically, with older versions of Access (I still have a 2000 system I'm maintaining), I've always used stored queries. However, that's not necessary any more. As I understand (limited) it:

Fewer stored queries means smaller databases.

TRUE

Stored queries are easier to manage.

TRUE

If a record source is a query based on one or more other queries, don't I still need to store the underlying queries?

YES

I think I would still want stored queries where there are multiple forms/reports based on the same.

YES

Please comment on this. What do I have wrong and what else am I missing?

IMO, the only reason to use SQL in a Record Source is when you want the form or report to be built on something dynamic - built at Open time.

You could have a similar discussion about Row Source in a combo or list box.

Thanks

Adam

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___