Re: Access 2003: How many queries?

Tom Lake

Guest

Posts: n/a

21st Dec 2006

> How many queries should a database with a lot of tables have?

As many as you need to do the job easily. There's no set rule
but if the query is only used occasionally, you might take the SQL
from the SQL view of the query and save it in a function in a module
rather than leave it as a query.

Tom Lake

« Update Query; But keep rest of field... | query gets wrong data from tables »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
many to many then one to many	=?Utf-8?B?U2hhcm9uSW5HYQ==?=	Microsoft Access Queries	1	26th Apr 2005 10:21 PM
I have MANY MANY MANY PROBLEMS - XP PRO	=?Utf-8?B?VGhlIEF1c3NpZSBHaXJs?=	Windows XP Help	5	16th Mar 2005 01:23 AM
Re: Is it possible that .net doesn't support Many to Many and Many to 1 relations?	chen qi	Microsoft ADO .NET	0	5th Jul 2004 08:30 AM
Many to Many (toooooo flippin many!!!)	=?Utf-8?B?R2luYSBTdGFycg==?=	Microsoft Access Queries	1	8th Jun 2004 02:38 PM
Re: 1 to many - many to many - many to 1	Miha Markic	Microsoft ADO .NET	3	23rd Jan 2004 06:00 PM